mysql数据库操作之通过更改表添加主键
- mysql> create table stu23(
- -> id int,
- -> name varchar(20)
- -> );
- Query OK, 0 rows affected (0.05 sec)
- -- 添加主键
- mysql> alter table stu23 add primary key(id);
- Query OK, 0 rows affected (0.09 sec)
- Records: 0 Duplicates: 0 Warnings: 0
复制代码
|
|