设置默认约束后在添加记录是必须要写出除默认约束列以外的完整列名才能生效,否则会报格式不正确异常
create table UserInfo(
user_id bigint primary key auto_increment,
user_name varchar(50) not null unique key,
user_pwd varchar(50) not null,
birthday date default now()
)
insert UserInfo(user_id,user_name,user_pwd) values('1','张三','123');