编辑代码

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);