| 1 |
CREATE TABLE t1 (pk INT PRIMARY KEY, a INT); |
| 2 |
INSERT INTO t1 VALUES (1,10),(2,20); |
| 3 |
CREATE TABLE t2 (b INT) PARTITION BY KEY (b) PARTITIONS 2; |
| 4 |
INSERT INTO t2 VALUES (1),(2); |
| 5 |
DELETE t2 FROM t2 WHERE b BETWEEN 5 AND 9; |
| 6 |
UPDATE t2 JOIN t1 SET b = 5; |
| 7 |
DROP TABLE t1, t2; |