SQL
INSERT: Single Row, Multi Row and INSERT SELECT
Every way to put rows into a table: explicit column lists, multi row VALUES, INSERT ... SELECT, defaults and handling duplicate keys.
DML
INSERT, UPDATE and DELETE, single row and multi row, done safely.
3 notes
Notes
SQL
UPDATE: Conditional and Multi Column Changes
UPDATE changes existing rows. Learn multi column updates, conditional logic with CASE, updates driven by a join and how to check the blast radius firs...
SQL
DELETE and Safe Data Modification
DELETE removes rows permanently. Learn targeted deletes, deleting through a join, soft deletes and the habits that stop a one line mistake becoming an...