MySQL里创建索引(Create Index)的方法和语法结构及例子
3677 点击·0 回帖
灯火互联
楼主
 |  | |
 | MySQL里创建索引(Create Index)的方法和语法结构及例子 CREATE INDEX Syntax CREATE [UNIQUE|FULLTEXT|SPATIAL] INDEX index_name [index_type] ON tbl_name (index_col_name,...) [index_type] www.atcpu.com index_col_name: col_name [(length)] [ASC | DESC] index_type: USING {BTREE | HASH | RTREE} [java] -- 创建无索引的表格 create table testNoPK ( id int not null, name varchar(10) ); -- 创建普通索引 create index IDX_testNoPK_Name on testNoPK (name); | |
 |  |