创建数据库索引

1.创建索引

?

alert table

?

?

CREATE INDEX index_name ON table_name (column_list)

CREATE UNIQUE INDEX index_name ON table_name (column_list)

?

?

2. 查看索引

?

mysql> show?index from tblname;

mysql> show keys from tblname;

?

?

?

-----

Reference:http://blog.chinaunix.net/space.php?uid=16362696&do=blog&id=2746788

?

?