mysql维护索引_MySQL->索引的维护[20180504]

));

ERROR 1214 (HY000): The used table type doesn't support FULLTEXT indexes

mysql> alter table index_tab01 engine=MyISAM;

Query OK, 0 rows affected (0.01 sec)

Records: 0 Duplicates: 0 Warnings: 0

mysql> alter table index_tab01 add fulltext index_02(col01,col02(30));

Query OK, 0 rows affected (0.00 sec)

Records: 0 Duplicates: 0 Warnings: 0

mysql> show index from index_tab01\G

*************************** 1. row ***************************

Table: index_tab01

Non_unique: 0

Key_name: PRIMARY

Seq_in_index: 1

Column_name: id

Collation: A

Cardinality: NULL

Sub_part: NULL

Packed: NULL

Null:

Index_type: BTREE

Comment:

*************************** 2. row ***************************

Table: index_tab01

Non_unique: 0

Key_name: PRIMARY

Seq_in_index: 2

Column_name: col01

Collation: A

Cardinality: 0

Sub_part: NULL

Packed: NULL

Null:

Index_type: BTREE

Comment:

*************************** 3. row ***************************

Table: index_tab01

Non_unique: 0

Key_name: index_un

Seq_in_index: 1

Column_name: col01

Collation: A

Cardinality: 0

Sub_part: NULL

Packed: NULL

Null:

Index_type: BTREE

Comment:

*************************** 4. row ***************************

Table: index_tab01

Non_unique: 1

Key_name: indx_01

Seq_in_index: 1

Column_name: col01

Collation: A

Cardinality: NULL

Sub_part: NULL

Packed: NULL

Null:

Index_type: BTREE

Comment:

*************************** 5. row ***************************

Table: index_tab01

Non_unique: 1

Key_name: index_02

Seq_in_index: 1

Column_name: col01

Collation: NULL

Cardinality: NULL

Sub_part: NULL

Packed: NULL

Null:

Index_type: FULLTEXT

Comment:

*************************** 6. row ***************************

Table: index_tab01

Non_unique: 1

Key_name: index_02

Seq_in_index: 2

Column_name: col02

Collation: NULL

Cardinality: NULL

Sub_part: NULL

Packed: NULL

Null: YES

Index_type: FULLTEXT

Comment:

6 rows in set (0.00 sec)