Question

What SQL syntax would you use to change data in a table if you only had READ access to the table? Having read access means the data manipulation would occur in the dataset rather than in the table being pulled from.

Answer 1

In case you have only READ access, then to change data, you would need to first create a view of the table and then change the data by editing the VIEW created.

The syntax to create a view is given as:

CREATE VIEW view_name AS
SELECT column1, column2, ...
FROM table_name
WHERE condition;

The syntax to update a view is given as:

UPDATE < view_name > SET<column1>=<value1>,<column2>=<value2>,.....
WHERE <condition>;