use sql_tutorial;
#表格属性的限制、约束
#not null不能为空
#unique 唯一不能重复
create table `student`(
`student_id` int,
`name` varchar(20) not null,
`major` varchar(20) unique,
primary key(`student_id`)
);
create table `student`(
`student_id` int,
`name` varchar(20),
`major` varchar(20) default('历史'),
primary key(`student_id`)
);
#insert into的自定义记录语句才会接受default约束
insert into `student` values(1,'小白');
#Error Code: 1136. Column count doesn't match value count at row 1
insert into `student`(`name`,`student_id`) values('小蓝',2);
use sql_tutorial;
create table `student`(
`student_id` int auto_increment,
`name` varchar(20),
`major` varchar(20) default('历史'),
primary key(`student_id`)
);
#填充表格中每一行的值
#insert into的自定义顺序填充的语句才会接受auto_increment语句
insert into `student` values('小白');
#Error Code: 1136. Column count doesn't match value count at row 1
insert into `student`(`name`) values('小蓝');
insert into `student` (`name`,`major`) values('小绿','生物');
语法内容总结:
1:约束有?
2:约束语句在insert into语句中不会报错?