The statements you use to add, change, or delete data are called data modification statements. The most common such statements include:
Insert adds new rows to a table
Update changes existing rows in a table
Delete removes specific rows from a table
Any single INSERT, UPDATE, or DELETE statement changes the data in only one table or view.
In addition to the common statements, the LOAD TABLE and TRUNCATE TABLE statements are especially useful for bulk loading and deleting of data.
Sometimes, the data modification statements are collectively known as the data modification language (DML) part of SQL.
Permissions for data modification
Transactions and data modification
Making changes permanent
Transactions and data recovery