创建多列索引
1,普通多列索引
mysql> ALTER TABLE index_test ADD index test( user_id, username );
Query OK, 0 rows affected (0.07 sec)
Records: 0 Duplicates: 0 Warnings: 0
2,多列唯一索引
mysql> ALTER TABLE index_test ADD unique test( user_id, username );
Query OK, 0 rows affected (0.06 sec)
Records: 0 Duplicates: 0 Warnings: 0
3,多列主键索引
mysql> ALTER TABLE index_test ADD primary key test( user_id, username );
Query OK, 0 rows affected (0.06 sec)
Records: 0 Duplicates: 0 Warnings: 0
我们主键一般都是ID,并且是自增长的,如果有,就要先删除主键后在创建多列主键索引,不然会报错的,ERROR 1068 (42000): Multiple primary key defined;
删除索引,可以用drop index test on index_test
转载于:https://blog.51cto.com/easonslove/1583394