DEFAULT约束:向列中插入默认值
创建表时添加DEFAULT约束
create table student(
cnou char(10) primary key,
stuno CHAR(11) ,
stuname VARCHAR(12),
cno varchar(8) ,
stusex CHAR(1) ,
schno CHAR(3) ,
Etime datetime DEFAULT now()
)
创建表后添加DEFAULT约束
alter table student
alter stuname set DEFAULT 'sname'
小知识:MYSQL不支持GETDATE()函数