create index創建索引, 我們先來看看語法吧.
CREATE INDEX index_name ON table_name (column_name)
創建唯一索引 SQL語法指數
創建一個獨特的指數上就座。重復值是不允許使用:
CREATE UNIQUE INDEX index_name ON table_name (column_name)我們來對person的man表創建sex 索引例子吧.CREATE INDEX PIndex ON Persons (LastName)來看個唯一索引CREATE INDEX PIndex ON Persons (LastName, FirstName)最後本站原創轉載注意: www.111cn.net/database/database.html