1 create table t1 (a bigint);
3 insert into t1 values(0);
5 Table Op Msg_type Msg_text
6 test.t1 analyze status OK
9 Table Op Msg_type Msg_text
10 test.t1 check status OK
12 create table t1 (a bigint);
13 insert into t1 values(0);
17 Table Op Msg_type Msg_text
18 test.t1 analyze status OK
21 Table Op Msg_type Msg_text
22 test.t1 check status OK
24 create table t1 (a bigint);
25 insert into t1 values(0);
27 Table Op Msg_type Msg_text
28 test.t1 analyze status OK
30 Table Op Msg_type Msg_text
31 test.t1 check status OK
33 create table t1 (a mediumtext, fulltext key key1(a)) charset utf8 collate utf8_general_ci engine myisam;
34 insert into t1 values ('hello');
36 Table Op Msg_type Msg_text
37 test.t1 analyze status OK
39 Table Op Msg_type Msg_text
40 test.t1 analyze status Table is already up to date
42 CREATE TABLE t1 (a int);
43 prepare stmt1 from "SELECT * FROM t1 PROCEDURE ANALYSE()";
45 Field_name Min_value Max_value Min_length Max_length Empties_or_zeros Nulls Avg_value_or_avg_length Std Optimal_fieldtype
47 Field_name Min_value Max_value Min_length Max_length Empties_or_zeros Nulls Avg_value_or_avg_length Std Optimal_fieldtype
48 deallocate prepare stmt1;
50 create temporary table t1(a int, index(a));
51 insert into t1 values('1'),('2'),('3'),('4'),('5');
53 Table Op Msg_type Msg_text
54 test.t1 analyze status OK
56 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment
57 t1 1 a 1 a A 5 NULL NULL YES BTREE
60 create table t1(a int);
61 analyze table t1 extended;
62 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'extended' at line 1
63 optimize table t1 extended;
64 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'extended' at line 1