页次: 1
格式:
create [unique|fulltext] index index_name on tb_name (field) [asc | desc]
示例
mysql> create table tb3 ( name char(20) ); Query OK, 0 rows affected (0.35 sec) mysql> create index name on tb3 (name); Query OK, 0 rows affected (0.37 sec) Records: 0 Duplicates: 0 Warnings: 0
ipbbs.net
离线
页次: 1