2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
8
a int unsigned not null auto_increment primary key,
12
a int unsigned not null auto_increment primary key,
15
INSERT INTO t1 VALUES (NULL, 0);
16
INSERT INTO t1 SELECT NULL, 0 FROM t1;
17
INSERT INTO t2 VALUES (NULL, 0), (NULL,1);
18
SELECT * FROM t1 ORDER BY a;
22
SELECT * FROM t2 ORDER BY a;
26
UPDATE t1, t2 SET t1.b = t2.b WHERE t1.a = t2.a;