创建数据库索引1.创建索引?alert table??CREATE INDEX index_name ON table_name (column_list)CREATE UNI
创建数据库索引
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
?
?