INSERT: INSERT INTO emp(name,salary) VALUES('Ram',50000); : Add new row(s) to a table

INSERT SET: INSERT INTO emp SET name='Asha',salary=40000; : MySQL variant offering column=value
syntax

ON DUPLICATE KEY UPDATE: INSERT INTO stats(id,val) VALUES(1,10) ON DUPLICATE KEY UPDATE
val=VALUES(val); : Upsert values when unique key conflict occurs

INSERT IGNORE: INSERT IGNORE INTO users(id,email) VALUES(1,'x@y.com'); : Skip insert errors such
as duplicates

REPLACE INTO: REPLACE INTO cache(key,val) VALUES('a','b'); : Delete conflicting row then insert new data

UPDATE: UPDATE emp SET salary=salary*1.05 WHERE dept='IT'; : Modify existing rows

UPDATE JOIN : UPDATE emp e JOIN dept d ON e.dept_id=d.id SET e.dept_name=d.name; : Update based on data from another table

DELETE: DELETE FROM logs WHERE created<DATE_SUB(NOW(),INTERVAL 30 DAY); : Remove rows matching condition

DELETE JOIN: DELETE a FROM a JOIN b ON a.id=b.id WHERE b.flag=0; : Delete with join criteria across tables

TRUNCATE: TRUNCATE TABLE temp_data; : Remove all rows quickly and reset auto increment

LOAD DATA INFILE: LOAD DATA INFILE '/tmp/file.csv' INTO TABLE t FIELDS TERMINATED BY ','; :
Bulk load data from file

CALL (proc): CALL raise_salary(1001,5000); : Execute stored procedure