编辑代码

CREATE DATABASE test;
use test;
CREATE TABLE student1 (
	id int primary key,
	name varchar(255) unique,
	address varchar(255) not null,
	city varchar(255) defualt 'wuhan'
);

INSERT INTO student1 VALUES (1, '刘一', '郑十家隔壁', '河南');
INSERT INTO student1 VALUES (2, '陈二',  '李四家隔壁', '安徽');
INSERT INTO student1 VALUES (3, '张三',  '白娘子家隔壁', '杭州');
INSERT INTO student1 VALUES (4, '李四',  '许仙家隔壁', '杭州');
INSERT INTO student1 VALUES (5, '王五',  '李四家隔壁', '杭州');
INSERT INTO student1 VALUES (6, '赵六',  '赵六家隔壁', '杭州');
INSERT INTO student1 VALUES (7, '孙七',  '张三家隔壁', '杭州');
INSERT INTO student1 VALUES (8, '周八',  '雷峰塔附近', '杭州');
INSERT INTO student1 VALUES (9, '吴九',  '孙七家隔壁', '杭州');
INSERT INTO student1 VALUES (10, '郑十',  '周八家隔壁');
 
SELECT * FROM student1;