Zi 字媒體

查詢 Index SHOW INDEX FROM 建立 Index -- ALTER TABLE ADD INDEX (); ALTER TABLE people ADD INDEX fname_lname_age (firstname,lastname,age); -- 建立也可以使用另一種寫法 -- CREATE INDEX IF NOT EXISTS on () CREATE INDEX priority on pod_listen (priority); 建立 Unique index -- ALTER TABLE ADD UNIQUE INDEX (); ALTER TABLE people ADD UNIQUE INDEX member (account); 刪除 Index -- ALTER TABLE DROP INDEX ALTER TABLE log DROP INDEX range_person_log Categories: MySQL 分類 Android AngularJS API Blueprint Chrome Database MySQL DataStructure Docker Editor Vim Firefox Git GitLab Google API Hadoop Language Go Java JavaScript jQuery jQueryChart Node.js Vue PHP Laravel ZendFramework Python Mac Network Cisco DLink Juniper Oauth Server Apache Share Unix FreeBSD Linux WebDesign Bootstrap CSS HTML Wordpress Search 搜尋關鍵字: