SQL-complete-tutorial

1
USE sql_store;
2

3
START TRANSACTION;
4

5
INSERT INTO orders (customer_id, order_date, status)
6
VALUES (1, '2019-01-01', 1);
7

8
INSERT INTO order_items
9
VALUES (LAST_INSERT_ID(), 1, 1, 1);
10

11
COMMIT;
12
-- ROLLBACK; this is an option to return to the previous stage;
13

14
SHOW VARIABLES LIKE 'autocommit'; -- set ON by default;