mysql 操作语句总结

一、索引
1、添加索引
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` );  
2、删除索引
ALTER TABLE `table_name` DROP PRIMARY KEY;
ALTER TABLE `table_name` DROP INDEX index_name;