49  DML (data manipulation language)

Data manipulation language statements are the statements that change the values in the tables. Most common three are following statements.

1. Insert
2. Update
3. Delete

These statements are C,U,D of CRUD (Create Read Update Delete) statements. But following statements are also considered data manipulation language statements

• Upsert
• Truncate Table
• Create Table AS Select or SELECT INTO

49.1 UPSERT

INSERT OR REPLACE https://www.sqlite.org/lang_replace.html https://www.sqlite.org/lang_conflict.html https://www.sqlite.org/lang_upsert.html

49.2 Data Import/Export