mysql索引

mysql索引

1 、查看表格中的索引

SHOW INDEX FROM table_name

2、添加索引

ALTER TABLE `table_name` ADD PRIMARY KEY ( `column` )  添加主键索引
ALTER TABLE `table_name` ADD UNIQUE ( `column` )  添加唯一索引
ALTER TABLE `table_name` ADD INDEX index_name ( `column` ) 添加普通索引
ALTER TABLE `table_name` ADD FULLTEXT ( `column`) 添加全文索引
ALTER TABLE `table_name` ADD INDEX index_name ( `column1`, `column2`, `column3` )添加联合索引

3、删除索引

drop index index_name on table_name