学习笔记(01):MySQL数据库从入门到实战应用-DDL之数据表

立即学习:https://edu.csdn.net/course/play/27328/362519?utm_source=blogtoedu

create table contacts(

              id int primary key,

              name varchar(30),

              phone varchar(11)

       );

desc contacts;

 

sex char(1)

 

alter table contacts add  sex char(1)

alter table contacts modify sex int(1)

alter table contacts drop column sex

 

drop table contacts;

show tables;