主键

1.

create table t1(
id int primary key
)

2.只有这种情况能省略primary关键字

create table t1(
id int key
)

3.

create table t2(
id int,
primary key(id)
)

4.

create table t3(id int);
alter table t3 modify id int primary key;

5.

create table t4(id int);
alter table t4 add primary key(id);

6.

alter table t5 drop primary key;

 

转载于:https://www.cnblogs.com/bibiafa/p/9209557.html