SQL: Inserting, Updating & Deleting Data

Learn to change data safely with SQL. Write INSERT, UPDATE and DELETE statements, insert from queries, avoid the infamous missing WHERE clause, use transactions to group changes and undo mistakes, and protect applications from SQL injection with parameterised queries. Examples tested in SQLite.

Examples were tested in SQLite 3. Syntax for transactions, returning generated keys and autocommit behaviour varies between database products and tools. Always test data changes on a copy first.