查詢 Index
SHOW INDEX FROM
建立 Index
-- ALTER TABLEADD 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 TABLEADD UNIQUE INDEX ( ); ALTER TABLE people ADD UNIQUE INDEX member (account);
刪除 Index
-- ALTER TABLEDROP INDEX ALTER TABLE log DROP INDEX range_person_log
Categories: MySQL