MYSQL列和约束的操作

1.查看列

desc person;

2.修改表名

alter table person rename to people;

3.添加、删除列

alter table person add column sex varchar(20); 

alter table person drop column name;

4.修改列名、列属性

alter table person change name name1 varchart(20);

alert table person modify name int;

5.查看表的所有信息

show create table person;

6.添加/删除主键、外键约束

alter table person add constraint PK_person primary key perosn(no);

alter table person add constraint FK_person_person2 foreign key person(no);

alter table person drop primary key;

alter table person drop foreign key FK_person_person2;