2.SQL表格属性

use `sql_tutorial`;
create table `student`(
`student_id` int auto_increment,
`name` varchar(20) not null,
`major` varchar(20) unique,
primary key(`student_id`)
);
drop table `student`;
insert into `student`(`name`,`major`) values('XAO','历');
SELECT * FROM student;
1
2
3
4
5
6
7
8
9
10