编辑代码

CREATE DATABASE test;
use test;
CREATE TABLE student (
	id int,
	name varchar(255),
	address varchar(255),
	city varchar(255)
);

INSERT INTO student VALUES (1, '小冬', '黄佳欣隔壁', '成都');
INSERT INTO student VALUES (2, '小瓜',  '黄佳欣家隔壁', '成都');
INSERT INTO student VALUES (3, '歪嘴',  '黄佳欣家隔壁', '成都');
INSERT INTO student VALUES (4, '',  '许仙家隔壁', '');
INSERT INTO student VALUES (5, '',  '李四家隔壁', '');
INSERT INTO student VALUES (6, '',  '赵六家隔壁', '');
INSERT INTO student VALUES (7, '',  '章鱼家隔壁', '');
INSERT INTO student VALUES (8, '',  '雷峰塔附近', '');
INSERT INTO student VALUES (9, '',  '孙七家隔壁', '');
INSERT INTO student VALUES (10, '',  '周八家隔壁', '');
 
SELECT * FROM student;