编辑代码

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

INSERT INTO student VALUES (1, '张三', '李四家隔壁', '杭州'),
                           (1, '李四', '张三家隔壁', '北京');
 

SELECT * FROM student;