How to write query when there is "read-only access" to the database ? What does it mean? e-CodePudding

Home > Back-end > How to write query when there is "read-only access" to the database ? What does it mean? e

How to write query when there is "read-only access" to the database ? What does it mean? e

Time：01-15

Table contains the following columns:

timestamp, date, customer_id, page_id

For example, query is:

for each customer, identify the first "page_id" that customer visited most recent day.

If there is a "read-only access" database. Are queries written differently?

Thanks in advance.

CodePudding user response：

Read-only access means you can only read and do query's that can read the database.

You won't be able to insert,update or drop tables.