SQL Advanced Database

Basic transaction

How do I commit or roll back multiple writes?

START TRANSACTION / COMMIT.

START TRANSACTION;
UPDATE accounts SET balance = balance - 100 WHERE id = 1;
UPDATE accounts SET balance = balance + 100 WHERE id = 2;
COMMIT;
-- ROLLBACK; if something failed

Notes

Use transactions for multi-step money/inventory updates.

Keywords: transaction · commit · rollback

SQL

CREATE DATABASE

How do I create a MySQL database?

SQL

ALTER TABLE add column

How do I add a column to an existing table?

SQL

Foreign key relationship

How do I relate posts to users?

SQL

COUNT with GROUP BY

How do I count rows per category?

SQL

LIKE search pattern

How do I search text with a keyword?

SQL

WHERE with AND / OR

How do I combine filters in SQL?