1
Table Op Msg_type Msg_text
2
test.t1 optimize status OK
3
Table Op Msg_type Msg_text
4
test.t1 check status OK
5
test.t2 check error The handler for the table doesn't support check/repair
6
Table Op Msg_type Msg_text
7
test.t1 repair status OK
8
test.t2 repair error The handler for the table doesn't support check/repair
9
Table Op Msg_type Msg_text
10
test.t2 check error The handler for the table doesn't support check/repair
11
test.t1 check status OK
12
Table Op Msg_type Msg_text
13
test.t2 check error Table 't2' was not locked with LOCK TABLES
14
test.t1 check status OK
15
Field Type Null Key Default Extra
19
Field Type Null Key Default Extra Privileges
20
a int(11) PRI 0 select,insert,update,references
21
b int(11) MUL 0 select,insert,update,references
22
c int(11) 0 select,insert,update,references
23
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment
24
t1 0 PRIMARY 1 a A 4 NULL NULL
25
t1 1 b 1 b A 1 NULL NULL
26
t1 1 b 2 c A 4 NULL NULL
27
Table Op Msg_type Msg_text
28
test.t1 check status Table is already up to date
29
Table Op Msg_type Msg_text
30
test.t1 check status Table is already up to date
31
Table Op Msg_type Msg_text
32
test.t1 check status OK
33
Table Op Msg_type Msg_text
34
test.t1 check status OK
35
Table Op Msg_type Msg_text
36
test.t1 check status OK
37
Table Op Msg_type Msg_text
38
test.t1 check status OK
39
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment
40
t1 0 PRIMARY 1 a A 5 NULL NULL
41
t1 1 b 1 b A 1 NULL NULL
42
t1 1 b 2 c A 5 NULL NULL
43
Table Op Msg_type Msg_text
44
test.t1 optimize status OK
45
Table Op Msg_type Msg_text
46
test.t1 optimize status Table is already up to date
52
Name Type Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Create_options Comment
58
Table Op Msg_type Msg_text
59
test.t1 analyze status OK
60
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment
61
t1 0 PRIMARY 1 f1 A 1 NULL NULL
62
t1 0 PRIMARY 2 f2 A 3 NULL NULL
63
t1 0 PRIMARY 3 f3 A 9 NULL NULL
64
t1 0 PRIMARY 4 f4 A 18 NULL NULL
65
Table Op Msg_type Msg_text
66
test.t1 repair status OK
67
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment
68
t1 0 PRIMARY 1 f1 A 1 NULL NULL
69
t1 0 PRIMARY 2 f2 A 3 NULL NULL
70
t1 0 PRIMARY 3 f3 A 9 NULL NULL
71
t1 0 PRIMARY 4 f4 A 18 NULL NULL
73
t1 CREATE TEMPORARY TABLE `t1` (
74
`a` int(11) NOT NULL default '0'
77
t2 CREATE TEMPORARY TABLE `t2` (
78
`a` int(11) NOT NULL default '0'
81
t1 CREATE TABLE `t1` (
82
`test_set` set('val1','val2','val3') NOT NULL default '',
83
`name` char(20) default 'O''Brien'
84
) TYPE=MyISAM COMMENT='it''s a table'
86
t1 CREATE TABLE `t1` (
87
`a` int(11) NOT NULL default '0',
91
t1 CREATE TABLE `t1` (
92
`a` int(11) NOT NULL default '0',
95
Field Type Null Key Default Extra
96
a decimal(9,2) YES NULL
97
b decimal(9,0) YES NULL
98
e double(9,2) YES NULL
99
f double(5,0) YES NULL
100
h float(3,2) YES NULL
101
i float(3,0) YES NULL
102
Field Type Null Key Default Extra
103
c decimal(10,0) YES NULL
107
Field Type Null Key Default Extra
108
c decimal(4,3) YES NULL
109
d double(4,3) YES NULL
110
f float(4,3) YES NULL