SQL DML Statements

Data Manipulation Language — INSERT, UPDATE, DELETE, REPLACE, MERGE. This category documents 28 SQL dml statements entries, and each page gives you the full syntax, the parameter list, the return value, and a runnable example tested against MySQL, PostgreSQL, SQL Server, and SQLite. The entries are: INSERT INTO, UPDATE, DELETE, REPLACE INTO, INSERT ... ON DUPLICATE KEY UPDATE, MERGE, INSERT INTO SELECT, UPSERT (PostgreSQL), DELETE with JOIN, UPDATE with FROM, INSERT DEFAULT VALUES, TRUNCATE ... RESTART IDENTITY, BULK INSERT, INSERT ALL (Oracle), DELETE Using TOP / LIMIT, INSERT ... EXEC, INSERT IGNORE, INSERT INTO ... SELECT * FROM (remote), TRUNCATE vs DELETE, UPDATE with Subquery, INSERT with DEFAULT VALUES (SQL Standard), UPDATE with TOP (SQL Server), DELETE with JOIN (PostgreSQL), OUTPUT INTO (SQL Server), INSERT EXEC (SQL Server), TRUNCATE with PARTITION, SQL CURSOR (Explicit Cursor), SQL DEFAULT Keyword. Not sure where to start? INSERT INTO and UPDATE are the most commonly used entries in this category. You can also search across every category from the search page, browse the complete A–Z index, or try any of these statements live in the SQL playground.