1DELETE FROM t1;
2INSERT INTO t1 VALUES(4, 'four'),(7,'seven'),(10,'ten'),(40,'forty'),(60,'sixty'),(81,'eighty one'),(72,'seventy two'),(11,'eleven'),(1,'one'),(35,'thirty five'),(8,'eight');
3SELECT * FROM t1;
4UPDATE t1 SET msg = 'bof' WHERE id = 35;
5SELECT * FROM t1;
6UPDATE t1 SET msg = 'big' WHERE id > 50;
7SELECT * FROM t1;
8UPDATE t1 SET msg = 'updated' WHERE id IN (8,35,60,72);
9SELECT * FROM t1;
10UPDATE t1 SET msg = 'twin' WHERE id IN (81,10);
11SELECT * FROM t1;
12UPDATE t1 SET msg = 'sixty' WHERE id = 60;
13SELECT * FROM t1 WHERE id = 60;
14DELETE FROM t1 WHERE id = 4;
15SELECT * FROM t1;
16DELETE FROM t1 WHERE id IN (40,11,35);
17SELECT * FROM t1;
18DELETE FROM t1 WHERE id IN (4,60,1);
19SELECT msg FROM t1;
20DELETE FROM t1 WHERE id IN (81,72);
21SELECT id FROM t1;
22DELETE FROM t1 WHERE id IN (7,10);
23SELECT * FROM t1;
24DELETE FROM t1 WHERE id = 8;
25SELECT * FROM t1;
26