gaodaima.com
MySQL里创建索引(Create Index)的方法和语法结本文来源gaodai#ma#com搞@@代~&码*网/构及例子 CREATE INDEX Syntax CREATE [UNIQUE|FULLTEXT|SPATIAL] INDEX index_name [index_type] ON tbl_name (index_col_name,…) [index_type] 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);
gaodaima.com