mirror of
https://github.com/MariaDB/server.git
synced 2026-02-24 03:28:46 +01:00
8f0e75285e
added: storage/connect/mysql-test/connect/r/updelx.result storage/connect/mysql-test/connect/t/updelx.inc storage/connect/mysql-test/connect/t/updelx.test
25 lines
858 B
SQL
25 lines
858 B
SQL
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;
|