SHOW INDEX FROM tbl_name
			
			

垂直顯示

			
SHOW INDEX FROM tbl_name\G
			
			

CREATE INDEX index_name
ON table_name (column_name)
			

CREATE UNIQUE INDEX

CREATE UNIQUE INDEX index_name
ON table_name (column_name)
			

			
DROP INDEX index_name ON tbl_name
			
			

			
SHOW INDEX FROM tbl_name
alter index IND_PK rebuild;