CREATE DATABASE test;
use test;
CREATE TABLE student (
id int primary key,
name varchar(255),
address varchar(255),
city varchar(255)
);
CREATE TABLE course(
id int primary key,
name varchar(10),
teacher varchar(5)
);
INSERT INTO course VALUES(1,'语文','王五');
INSERT INTO course VALUES(2,'数学','李四');
INSERT INTO course VALUES(3,'生物','张三');
INSERT INTO course VALUES(4,'化学','刘大');
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;
SELECT * FROM course;