Home | Mirror | Search

3. Index

3.1. SHOW INDEX

			
SHOW INDEX FROM tbl_name
			
			

垂直顯示

			
SHOW INDEX FROM tbl_name\G
			
			

3.2. CREATE INDEX

CREATE INDEX index_name
ON table_name (column_name)
			

CREATE UNIQUE INDEX

CREATE UNIQUE INDEX index_name
ON table_name (column_name)
			

3.3. DROP INDEX

			
DROP INDEX index_name ON tbl_name
			
			

3.4. rebuild

			
SHOW INDEX FROM tbl_name
alter index IND_PK rebuild;
			
			
comments powered by Disqus