一、表结构
1.1、约束条件
mysql> create table db3.t2(
-> name char(10) not null default "", #不能为空值,当没有赋值时,默认赋值为“”;
-> sex enum("boy","girl") default "boy", #当没有赋值时,默认赋值为boy;
-> likes set("eat","game","money","it") not null default "eat,money")
mysql> desc db3.t2; #查看表结构
mysql> inset into db3.t2 values(); #都不赋值,查看赋的默认值
mysql> insert into db3.t2(name) values("mao"); #只赋值给name字段
1.2、修改表结构
mysql> alter table t2 add class char(7)default "nsd1911" first