blob: 9e8e1b81687294441a137f60e268288f1932ee75 (
plain)
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
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
|
a b
1 Testing
2 table
3 t1
1 Testing
2 table
3 t2
a b
3 t1
3 t2
2 table
2 table
1 Testing
1 Testing
table type possible_keys key key_len ref rows Extra
t3 range a a 4 NULL 10 where used
table type possible_keys key key_len ref rows Extra
t3 range a a 4 NULL 10 where used
a b
10 Testing
10 Testing
a b
1 Testing
1 Testing
2 table
2 table
3 t1
3 t2
4 Testing
4 Testing
5 table
5 table
6 t1
6 t2
7 Testing
7 Testing
8 table
8 table
9 t2
9 t2
a b
11 table
11 table
12 t1
12 t1
13 Testing
13 Testing
14 table
14 table
15 t2
15 t2
16 Testing
16 Testing
17 table
17 table
18 t2
18 t2
19 Testing
19 Testing
table type possible_keys key key_len ref rows Extra
t3 index NULL a 4 NULL 1131 Using index
a
699
698
697
696
695
694
693
692
691
690
a
416
415
415
414
414
413
413
412
412
411
Table Create Table
t3 CREATE TABLE `t3` (
`a` int(11) NOT NULL default '0',
`b` char(20) default NULL,
KEY `a` (`a`)
) TYPE=MRG_MyISAM UNION=(t1,t2)
c
test1
test1
test1
test2
test2
test2
c
test1
test1
test1
test2
test2
test2
c
c
incr othr
incr othr
1 10
2 24
4 33
3 53
count(*)
10
count(*)
20
count(*)
20
Table Create Table
t3 CREATE TABLE `t3` (
`incr` int(11) NOT NULL default '0',
`othr` int(11) NOT NULL default '0',
PRIMARY KEY (`incr`)
) TYPE=MRG_MyISAM UNION=(t1,t2)
Table Create Table
t3 CREATE TABLE `t3` (
`incr` int(11) NOT NULL default '0',
`othr` int(11) NOT NULL default '0'
) TYPE=MRG_MyISAM UNION=(t1,t2)
a
|
