1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
|
use test;
drop table if exists test1,test2;
create table test1(
a int not null,
b int not null,
c int not null
) ENGINE=INNODB;
create table test2(
a int not null,
b int not null,
c int not null
) ENGINE=INNODB;
insert into test1 values
(1, 2, 3),
(1, 2, 3),
(1, 2, 3),
(1, 2, 3),
(2, 2, 3),
(2, 2, 3),
(2, 2, 3),
(2, 2, 3),
(3, 2, 3),
(3, 2, 3);
insert into test2 values
(1, 2, 3),
(1, 2, 3),
(1, 2, 3),
(2, 2, 3),
(2, 2, 3),
(2, 2, 3),
(2, 2, 3),
(2, 2, 3),
(2, 2, 3),
(4, 2, 3);
|
