508
508
PRIMARY KEY (pk1,pk2,pk3,pk4)
511
insert into t2 select 1, A.a+10*B.a, 432, 44, 'fillerZ' from t1 A CROSS JOIN t1 B;
511
insert into t2 select 1, A.a+10*B.a, 432, 44, 'fillerZ' from t1 A, t1 B;
512
512
INSERT INTO t2 VALUES (2621, 2635, 0, 0,'filler'), (2621, 2635, 1, 0,'filler'),
513
513
(2621, 2635, 10, 0,'filler'), (2621, 2635, 11, 0,'filler'),
514
514
(2621, 2635, 14, 0,'filler'), (2621, 2635, 1000015, 0,'filler');