I want to know what exactly the terms "Read" and "Write" operations mean in SQL.

In SQL, I think:

• "Read" means SELECT.

• "Write" means INSERT, UPDATE or DELETE.

Is my understanding of the terms "Read" and "Write" in SQL above correct?

CodePudding user response：

You are correct.

Read is an operation that retrieves data from the database, while write is an operation that inserts, updates or deletes data in the database.

CodePudding user response：

Yes. There are other statements that performs writes (create, alter, drop etc).