create database chapter07;
use chapter07;
CREATE TABLE stu (
s_id INT(11) PRIMARY KEY,
s_name VARCHAR(20) NOT NULL,
addr VARCHAR(50) NOT NULL,
tel VARCHAR(50) NOT NULL
);
INSERT INTO stu
VALUES
(1,'ZhangPeng','Hebei','13889075861'),
(2,'LiXiao','Shandong','13953508223'),
(3,'HuangYun','Shandong','13905350996');
CREATE TABLE sign (
s_id INT(11) PRIMARY KEY,
s_name VARCHAR(20) NOT NULL,
s_sch VARCHAR(50) NOT NULL,
s_sign_sch VARCHAR(50) NOT NULL
);
INSERT INTO sign
VALUES
(1,'ZhangPeng','High School1','Peking University'),
(2,'LiXiao','High School2','Peking University'),
(3,'HuangYun','High School3','Tsinghua University');
CREATE TABLE stu_mark
(
s_id INT(11) PRIMARY KEY,
s_name VARCHAR(20) NOT NULL,
mark INT NOT NULL
);
INSERT INTO stu_mark
VALUES
(1,'ZhangPeng',730),
(2,'LiXiao',725),
(3,'HuangYun',736);