Common: Data Manipulation — Sven Jansson learn.common.org

​Commitment / Transaction Control Introduction INSERT
Insert a single (or multiple rows) by column listing
Insert rows based on a SELECT Statement
UPDATE
Update a single Value / multiple Values / Single Row / Multiple Rows
Update a Table from another table
DELETE
Delete a Single Row / multiple Rows
Delete based on a SELECT Statement
Using LIMIT (and OFFSET) in composition with INSERT/UPDATE/DELETE Read More 

Verified by MonsterInsights