1.添加普通索引:alter table + 表名+add +index(表头);
eg:alter table user add index(username);
2.添加唯一索引:alter table +表名+add+unique(表头);
eg:alter table user add unique(password);
3.添加全文索引:alter alter+表名+add+fulltext(表头);
eg:alter table user add fulltext(address);
4.添加主键索引:alter table +表名+add+primary key(表头);
eg:alter table user add primary key(id);
5.查看哪些加了索引:show index from +表名;
eg:show index from user;
6.查看当前表在那个数据库下面:select database();
mysql添加索引语句
最新推荐文章于 2022-04-22 13:33:45 发布