MySQL里创建索引(Create Index)的方法和语法结构及例子_MySQL

bitsCN.com
MySQL里创建索引(Create Index)的方法和语法结构及例子 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); 
  bitsCN.com