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
40
41
42
43
44
45
46
47
48
49
50
51
52
|
drop table if exists tab;
drop table if exists tbc;
create table tab (a int, b int) engine=tokudb;
insert into tab values (1,1),(2,1),(2,2),(3,1),(3,2),(3,3);
select * from tab;
a b
1 1
2 1
2 2
3 1
3 2
3 3
create table tbc (b int, c int) engine=myisam;
insert into tbc values (2,4),(3,9),(3,27),(4,1);
select * from tbc;
b c
2 4
3 9
3 27
4 1
select a,tab.b,c from tab join tbc on tab.b = tbc.b;
a b c
2 2 4
3 2 4
3 3 9
3 3 27
select a,tab.b,tbc.b,c from tab join tbc on tab.b < tbc.b;
a b b c
1 1 2 4
1 1 3 9
1 1 3 27
1 1 4 1
2 1 2 4
2 1 3 9
2 1 3 27
2 1 4 1
2 2 3 9
2 2 3 27
2 2 4 1
3 1 2 4
3 1 3 9
3 1 3 27
3 1 4 1
3 2 3 9
3 2 3 27
3 2 4 1
3 3 4 1
select a,tab.b,tbc.b,c from tab join tbc on tab.b > tbc.b;
a b b c
3 3 2 4
drop table tab;
drop table tbc;
|