1DROP TABLE IF EXISTS t1,t2,t3; 2CREATE TABLE t1 (c1 TINYINT NOT NULL PRIMARY KEY, c2 TINYINT); 3INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 4CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 TINYINT, new1 TINYINT, old2 TINYINT, new2 TINYINT); 5CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY, c2 TINYINT); 6INSERT INTO t3 VALUES(1,0); 7CREATE TRIGGER tr1 AFTER UPDATE ON t1 FOR EACH ROW BEGIN 8INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c2); 9UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 10SET NEW.c2=100; 11END// 12ERROR HY000: Updating of NEW row is not allowed in after trigger 13CREATE TRIGGER tr1 BEFORE UPDATE ON t1 FOR EACH ROW BEGIN 14INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c2); 15UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 16SET NEW.c2=100; 17END// 18UPDATE t1 SET c2=10 WHERE c1=1; 19UPDATE t1 SET c2=10 WHERE c1=0; 20UPDATE t1 SET c2=10 WHERE c1=NULL; 21UPDATE t1 SET c2=10 WHERE c1=6 OR c1=7; 22UPDATE t1 SET c2=10 WHERE c2=3; 23SELECT * FROM t1 ORDER BY c1; 24c1 c2 251 100 262 2 273 100 284 4 296 100 307 100 318 8 329 9 3310 10 34SELECT * FROM t2 ORDER BY c1; 35c1 old1 new1 old2 new2 361 1 1 1 10 372 6 6 6 10 383 7 7 7 10 394 3 3 3 10 40SELECT * FROM t3 ORDER BY c1; 41c1 c2 421 40 43DROP TABLE t1,t2,t3; 44CREATE TABLE t1 (c1 SMALLINT NOT NULL PRIMARY KEY, c2 SMALLINT); 45INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 46CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 SMALLINT, new1 SMALLINT, old2 SMALLINT, new2 SMALLINT); 47CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY, c2 SMALLINT); 48INSERT INTO t3 VALUES(1,0); 49CREATE TRIGGER tr1 AFTER UPDATE ON t1 FOR EACH ROW BEGIN 50INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c2); 51UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 52SET NEW.c2=100; 53END// 54ERROR HY000: Updating of NEW row is not allowed in after trigger 55CREATE TRIGGER tr1 BEFORE UPDATE ON t1 FOR EACH ROW BEGIN 56INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c2); 57UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 58SET NEW.c2=100; 59END// 60UPDATE t1 SET c2=10 WHERE c1=1; 61UPDATE t1 SET c2=10 WHERE c1=0; 62UPDATE t1 SET c2=10 WHERE c1=NULL; 63UPDATE t1 SET c2=10 WHERE c1=6 OR c1=7; 64UPDATE t1 SET c2=10 WHERE c2=3; 65SELECT * FROM t1 ORDER BY c1; 66c1 c2 671 100 682 2 693 100 704 4 716 100 727 100 738 8 749 9 7510 10 76SELECT * FROM t2 ORDER BY c1; 77c1 old1 new1 old2 new2 781 1 1 1 10 792 6 6 6 10 803 7 7 7 10 814 3 3 3 10 82SELECT * FROM t3 ORDER BY c1; 83c1 c2 841 40 85DROP TABLE t1,t2,t3; 86CREATE TABLE t1 (c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 MEDIUMINT); 87INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 88CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 MEDIUMINT, new1 MEDIUMINT, old2 MEDIUMINT, new2 MEDIUMINT); 89CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY, c2 MEDIUMINT); 90INSERT INTO t3 VALUES(1,0); 91CREATE TRIGGER tr1 AFTER UPDATE ON t1 FOR EACH ROW BEGIN 92INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c2); 93UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 94SET NEW.c2=100; 95END// 96ERROR HY000: Updating of NEW row is not allowed in after trigger 97CREATE TRIGGER tr1 BEFORE UPDATE ON t1 FOR EACH ROW BEGIN 98INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c2); 99UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 100SET NEW.c2=100; 101END// 102UPDATE t1 SET c2=10 WHERE c1=1; 103UPDATE t1 SET c2=10 WHERE c1=0; 104UPDATE t1 SET c2=10 WHERE c1=NULL; 105UPDATE t1 SET c2=10 WHERE c1=6 OR c1=7; 106UPDATE t1 SET c2=10 WHERE c2=3; 107SELECT * FROM t1 ORDER BY c1; 108c1 c2 1091 100 1102 2 1113 100 1124 4 1136 100 1147 100 1158 8 1169 9 11710 10 118SELECT * FROM t2 ORDER BY c1; 119c1 old1 new1 old2 new2 1201 1 1 1 10 1212 6 6 6 10 1223 7 7 7 10 1234 3 3 3 10 124SELECT * FROM t3 ORDER BY c1; 125c1 c2 1261 40 127DROP TABLE t1,t2,t3; 128CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INT); 129INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 130CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 INT, new1 INT, old2 INT, new2 INT); 131CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY, c2 INT); 132INSERT INTO t3 VALUES(1,0); 133CREATE TRIGGER tr1 AFTER UPDATE ON t1 FOR EACH ROW BEGIN 134INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c2); 135UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 136SET NEW.c2=100; 137END// 138ERROR HY000: Updating of NEW row is not allowed in after trigger 139CREATE TRIGGER tr1 BEFORE UPDATE ON t1 FOR EACH ROW BEGIN 140INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c2); 141UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 142SET NEW.c2=100; 143END// 144UPDATE t1 SET c2=10 WHERE c1=1; 145UPDATE t1 SET c2=10 WHERE c1=0; 146UPDATE t1 SET c2=10 WHERE c1=NULL; 147UPDATE t1 SET c2=10 WHERE c1=6 OR c1=7; 148UPDATE t1 SET c2=10 WHERE c2=3; 149SELECT * FROM t1 ORDER BY c1; 150c1 c2 1511 100 1522 2 1533 100 1544 4 1556 100 1567 100 1578 8 1589 9 15910 10 160SELECT * FROM t2 ORDER BY c1; 161c1 old1 new1 old2 new2 1621 1 1 1 10 1632 6 6 6 10 1643 7 7 7 10 1654 3 3 3 10 166SELECT * FROM t3 ORDER BY c1; 167c1 c2 1681 40 169DROP TABLE t1,t2,t3; 170CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER); 171INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 172CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 INTEGER, new1 INTEGER, old2 INTEGER, new2 INTEGER); 173CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY, c2 INTEGER); 174INSERT INTO t3 VALUES(1,0); 175CREATE TRIGGER tr1 AFTER UPDATE ON t1 FOR EACH ROW BEGIN 176INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c2); 177UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 178SET NEW.c2=100; 179END// 180ERROR HY000: Updating of NEW row is not allowed in after trigger 181CREATE TRIGGER tr1 BEFORE UPDATE ON t1 FOR EACH ROW BEGIN 182INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c2); 183UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 184SET NEW.c2=100; 185END// 186UPDATE t1 SET c2=10 WHERE c1=1; 187UPDATE t1 SET c2=10 WHERE c1=0; 188UPDATE t1 SET c2=10 WHERE c1=NULL; 189UPDATE t1 SET c2=10 WHERE c1=6 OR c1=7; 190UPDATE t1 SET c2=10 WHERE c2=3; 191SELECT * FROM t1 ORDER BY c1; 192c1 c2 1931 100 1942 2 1953 100 1964 4 1976 100 1987 100 1998 8 2009 9 20110 10 202SELECT * FROM t2 ORDER BY c1; 203c1 old1 new1 old2 new2 2041 1 1 1 10 2052 6 6 6 10 2063 7 7 7 10 2074 3 3 3 10 208SELECT * FROM t3 ORDER BY c1; 209c1 c2 2101 40 211DROP TABLE t1,t2,t3; 212CREATE TABLE t1 (c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT); 213INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 214CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 BIGINT, new1 BIGINT, old2 BIGINT, new2 BIGINT); 215CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY, c2 BIGINT); 216INSERT INTO t3 VALUES(1,0); 217CREATE TRIGGER tr1 AFTER UPDATE ON t1 FOR EACH ROW BEGIN 218INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c2); 219UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 220SET NEW.c2=100; 221END// 222ERROR HY000: Updating of NEW row is not allowed in after trigger 223CREATE TRIGGER tr1 BEFORE UPDATE ON t1 FOR EACH ROW BEGIN 224INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c2); 225UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 226SET NEW.c2=100; 227END// 228UPDATE t1 SET c2=10 WHERE c1=1; 229UPDATE t1 SET c2=10 WHERE c1=0; 230UPDATE t1 SET c2=10 WHERE c1=NULL; 231UPDATE t1 SET c2=10 WHERE c1=6 OR c1=7; 232UPDATE t1 SET c2=10 WHERE c2=3; 233SELECT * FROM t1 ORDER BY c1; 234c1 c2 2351 100 2362 2 2373 100 2384 4 2396 100 2407 100 2418 8 2429 9 24310 10 244SELECT * FROM t2 ORDER BY c1; 245c1 old1 new1 old2 new2 2461 1 1 1 10 2472 6 6 6 10 2483 7 7 7 10 2494 3 3 3 10 250SELECT * FROM t3 ORDER BY c1; 251c1 c2 2521 40 253DROP TABLE t1,t2,t3; 254CREATE TABLE t1 (c1 REAL NOT NULL PRIMARY KEY, c2 REAL); 255INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 256CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 REAL, new1 REAL, old2 REAL, new2 REAL); 257CREATE TABLE t3(c1 REAL NOT NULL PRIMARY KEY, c2 REAL); 258INSERT INTO t3 VALUES(1,0); 259CREATE TRIGGER tr1 AFTER UPDATE ON t1 FOR EACH ROW BEGIN 260INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c2); 261UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 262SET NEW.c2=100; 263END// 264ERROR HY000: Updating of NEW row is not allowed in after trigger 265CREATE TRIGGER tr1 BEFORE UPDATE ON t1 FOR EACH ROW BEGIN 266INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c2); 267UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 268SET NEW.c2=100; 269END// 270UPDATE t1 SET c2=10 WHERE c1=1; 271UPDATE t1 SET c2=10 WHERE c1=0; 272UPDATE t1 SET c2=10 WHERE c1=NULL; 273UPDATE t1 SET c2=10 WHERE c1=6 OR c1=7; 274UPDATE t1 SET c2=10 WHERE c2=3; 275SELECT * FROM t1 ORDER BY c1; 276c1 c2 2771 100 2782 2 2793 100 2804 4 2816 100 2827 100 2838 8 2849 9 28510 10 286SELECT * FROM t2 ORDER BY c1; 287c1 old1 new1 old2 new2 2881 1 1 1 10 2892 6 6 6 10 2903 7 7 7 10 2914 3 3 3 10 292SELECT * FROM t3 ORDER BY c1; 293c1 c2 2941 40 295DROP TABLE t1,t2,t3; 296CREATE TABLE t1 (c1 DOUBLE NOT NULL PRIMARY KEY, c2 DOUBLE); 297INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 298CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 DOUBLE, new1 DOUBLE, old2 DOUBLE, new2 DOUBLE); 299CREATE TABLE t3(c1 DOUBLE NOT NULL PRIMARY KEY, c2 DOUBLE); 300INSERT INTO t3 VALUES(1,0); 301CREATE TRIGGER tr1 AFTER UPDATE ON t1 FOR EACH ROW BEGIN 302INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c2); 303UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 304SET NEW.c2=100; 305END// 306ERROR HY000: Updating of NEW row is not allowed in after trigger 307CREATE TRIGGER tr1 BEFORE UPDATE ON t1 FOR EACH ROW BEGIN 308INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c2); 309UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 310SET NEW.c2=100; 311END// 312UPDATE t1 SET c2=10 WHERE c1=1; 313UPDATE t1 SET c2=10 WHERE c1=0; 314UPDATE t1 SET c2=10 WHERE c1=NULL; 315UPDATE t1 SET c2=10 WHERE c1=6 OR c1=7; 316UPDATE t1 SET c2=10 WHERE c2=3; 317SELECT * FROM t1 ORDER BY c1; 318c1 c2 3191 100 3202 2 3213 100 3224 4 3236 100 3247 100 3258 8 3269 9 32710 10 328SELECT * FROM t2 ORDER BY c1; 329c1 old1 new1 old2 new2 3301 1 1 1 10 3312 6 6 6 10 3323 7 7 7 10 3334 3 3 3 10 334SELECT * FROM t3 ORDER BY c1; 335c1 c2 3361 40 337DROP TABLE t1,t2,t3; 338CREATE TABLE t1 (c1 FLOAT NOT NULL PRIMARY KEY, c2 FLOAT); 339INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 340CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 FLOAT, new1 FLOAT, old2 FLOAT, new2 FLOAT); 341CREATE TABLE t3(c1 FLOAT NOT NULL PRIMARY KEY, c2 FLOAT); 342INSERT INTO t3 VALUES(1,0); 343CREATE TRIGGER tr1 AFTER UPDATE ON t1 FOR EACH ROW BEGIN 344INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c2); 345UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 346SET NEW.c2=100; 347END// 348ERROR HY000: Updating of NEW row is not allowed in after trigger 349CREATE TRIGGER tr1 BEFORE UPDATE ON t1 FOR EACH ROW BEGIN 350INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c2); 351UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 352SET NEW.c2=100; 353END// 354UPDATE t1 SET c2=10 WHERE c1=1; 355UPDATE t1 SET c2=10 WHERE c1=0; 356UPDATE t1 SET c2=10 WHERE c1=NULL; 357UPDATE t1 SET c2=10 WHERE c1=6 OR c1=7; 358UPDATE t1 SET c2=10 WHERE c2=3; 359SELECT * FROM t1 ORDER BY c1; 360c1 c2 3611 100 3622 2 3633 100 3644 4 3656 100 3667 100 3678 8 3689 9 36910 10 370SELECT * FROM t2 ORDER BY c1; 371c1 old1 new1 old2 new2 3721 1 1 1 10 3732 6 6 6 10 3743 7 7 7 10 3754 3 3 3 10 376SELECT * FROM t3 ORDER BY c1; 377c1 c2 3781 40 379DROP TABLE t1,t2,t3; 380CREATE TABLE t1 (c1 DECIMAL NOT NULL PRIMARY KEY, c2 DECIMAL); 381INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 382CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 DECIMAL, new1 DECIMAL, old2 DECIMAL, new2 DECIMAL); 383CREATE TABLE t3(c1 DECIMAL NOT NULL PRIMARY KEY, c2 DECIMAL); 384INSERT INTO t3 VALUES(1,0); 385CREATE TRIGGER tr1 AFTER UPDATE ON t1 FOR EACH ROW BEGIN 386INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c2); 387UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 388SET NEW.c2=100; 389END// 390ERROR HY000: Updating of NEW row is not allowed in after trigger 391CREATE TRIGGER tr1 BEFORE UPDATE ON t1 FOR EACH ROW BEGIN 392INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c2); 393UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 394SET NEW.c2=100; 395END// 396UPDATE t1 SET c2=10 WHERE c1=1; 397UPDATE t1 SET c2=10 WHERE c1=0; 398UPDATE t1 SET c2=10 WHERE c1=NULL; 399UPDATE t1 SET c2=10 WHERE c1=6 OR c1=7; 400UPDATE t1 SET c2=10 WHERE c2=3; 401SELECT * FROM t1 ORDER BY c1; 402c1 c2 4031 100 4042 2 4053 100 4064 4 4076 100 4087 100 4098 8 4109 9 41110 10 412SELECT * FROM t2 ORDER BY c1; 413c1 old1 new1 old2 new2 4141 1 1 1 10 4152 6 6 6 10 4163 7 7 7 10 4174 3 3 3 10 418SELECT * FROM t3 ORDER BY c1; 419c1 c2 4201 40 421DROP TABLE t1,t2,t3; 422CREATE TABLE t1 (c1 NUMERIC NOT NULL PRIMARY KEY, c2 NUMERIC); 423INSERT INTO t1 VALUES(1,1),(2,2),(3,3),(4,4),(6,6),(7,7),(8,8),(9,9),(10,10); 424CREATE TABLE t2(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, old1 NUMERIC, new1 NUMERIC, old2 NUMERIC, new2 NUMERIC); 425CREATE TABLE t3(c1 NUMERIC NOT NULL PRIMARY KEY, c2 NUMERIC); 426INSERT INTO t3 VALUES(1,0); 427CREATE TRIGGER tr1 AFTER UPDATE ON t1 FOR EACH ROW BEGIN 428INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c2); 429UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 430SET NEW.c2=100; 431END// 432ERROR HY000: Updating of NEW row is not allowed in after trigger 433CREATE TRIGGER tr1 BEFORE UPDATE ON t1 FOR EACH ROW BEGIN 434INSERT INTO t2 (old1,new1,old2,new2) VALUES(OLD.c1,NEW.c1,OLD.c2,NEW.c2); 435UPDATE t3 SET c2 = c2 + NEW.c2 WHERE c1 = 1; 436SET NEW.c2=100; 437END// 438UPDATE t1 SET c2=10 WHERE c1=1; 439UPDATE t1 SET c2=10 WHERE c1=0; 440UPDATE t1 SET c2=10 WHERE c1=NULL; 441UPDATE t1 SET c2=10 WHERE c1=6 OR c1=7; 442UPDATE t1 SET c2=10 WHERE c2=3; 443SELECT * FROM t1 ORDER BY c1; 444c1 c2 4451 100 4462 2 4473 100 4484 4 4496 100 4507 100 4518 8 4529 9 45310 10 454SELECT * FROM t2 ORDER BY c1; 455c1 old1 new1 old2 new2 4561 1 1 1 10 4572 6 6 6 10 4583 7 7 7 10 4594 3 3 3 10 460SELECT * FROM t3 ORDER BY c1; 461c1 c2 4621 40 463DROP TABLE t1,t2,t3; 464