索引的创建
Create index语句:create (online/offline) (unique/fulltext/spatial) index *** (using btree/hash) on ***(***(length) (asc/desc),….);
不能创建主键
Create table语句:(constraint ***) primary key ***(***,…)
Index/key ***(***,…)
(constraint ***) unique (index/key) ***(***,…)
Fulltext/spatial (idex/key) ***(***,…)
(constraint ***) foreign key ***(***,…) …
Alter table语句:add+上述语句