EVOLUTION-MANAGER

Edit File: updelx.inc

DELETE FROM t1; INSERT 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'); SELECT * FROM t1; UPDATE t1 SET msg = 'bof' WHERE id = 35; SELECT * FROM t1; UPDATE t1 SET msg = 'big' WHERE id > 50; SELECT * FROM t1; UPDATE t1 SET msg = 'updated' WHERE id IN (8,35,60,72); SELECT * FROM t1; UPDATE t1 SET msg = 'twin' WHERE id IN (81,10); SELECT * FROM t1; UPDATE t1 SET msg = 'sixty' WHERE id = 60; SELECT * FROM t1 WHERE id = 60; DELETE FROM t1 WHERE id = 4; SELECT * FROM t1; DELETE FROM t1 WHERE id IN (40,11,35); SELECT * FROM t1; DELETE FROM t1 WHERE id IN (4,60,1); SELECT msg FROM t1; DELETE FROM t1 WHERE id IN (81,72); SELECT id FROM t1; DELETE FROM t1 WHERE id IN (7,10); SELECT * FROM t1; DELETE FROM t1 WHERE id = 8; SELECT * FROM t1;