mysql怎么创建索引？

最新推荐文章于 2024-12-06 20:42:12 发布

fun. 逗~

最新推荐文章于 2024-12-06 20:42:12 发布

阅读量445

点赞数 8

文章标签： mysql 数据库

本文链接：https://blog.csdn.net/qq_43539664/article/details/137055408

版权

                    
                        
                    
                    索引类型建表时建表后
主键索引create table t(id int primary key);
create table t(id int, primary key(id));alter table t add primary key(id);
单值索引create table t(a int, index(a));
create table t(a int, key(a));
create table t(a int, index index_name (a));alter table t add index (a);
alter table t add key (a);
alter table t add index index_name (a);
alter table t add key key_name (a);
create index index_name on t(a);
唯一索引create table t(a int unique);
create table t(a int, unique(a));
create table t(a int, unique unique_name (a));
create table t(a int, unique index index_name (a));
create table t(a int, unique key key_name (a));alter table t add unique (a);
alter table t add unique unique_name (a);
alter table t add unique index (a);
alter table t add unique key (a);
alter table t add unique index index_name (a);
alter table t add unique key key_name (a);
create unique index index_name on t(a);
复合索引create table t(a int, b int, index(a,b));
create table t(a int, b int, key(a,b));
create table t(a int, b int, index index _name (a,b));
create table t(a int, b int, key key_name (a,b));alter table t add index (a,b);
alter table t add key (a,b);
alter table t add index index_name (a,b);
alter table t add key key_name (a,b);
create index index_name on t(a,b);

                

索引类型	建表时	建表后
主键索引	create table t(id int primary key); create table t(id int, primary key(id));	alter table t add primary key(id);
单值索引	create table t(a int, index(a)); create table t(a int, key(a)); create table t(a int, index index_name (a));	alter table t add index (a); alter table t add key (a); alter table t add index index_name (a); alter table t add key key_name (a); create index index_name on t(a);
唯一索引	create table t(a int unique); create table t(a int, unique(a)); create table t(a int, unique unique_name (a)); create table t(a int, unique index index_name (a)); create table t(a int, unique key key_name (a));	alter table t add unique (a); alter table t add unique unique_name (a); alter table t add unique index (a); alter table t add unique key (a); alter table t add unique index index_name (a); alter table t add unique key key_name (a); create unique index index_name on t(a);
复合索引	create table t(a int, b int, index(a,b)); create table t(a int, b int, key(a,b)); create table t(a int, b int, index index _name (a,b)); create table t(a int, b int, key key_name (a,b));	alter table t add index (a,b); alter table t add key (a,b); alter table t add index index_name (a,b); alter table t add key key_name (a,b); create index index_name on t(a,b);