MySql 默认值约束

 

# 创建books9,对date默认值设置为”无“

create table books9(

        id int(8),

        name varchar(30),

        price float(3),

date varchar(30) default '无'

)

# 创建表books10，对name默认值设置为”李四“

create table books10(

        id int(8),

        name varchar(30),

        price float(3),

        date varchar(30)

)

alter table books10 modify name varchar(30) default '李四'

# 删除表books10,name默认字段为”李四“的约束

alter table books10 modify name varchar(30)