SQLize | PHPize | SQLtest

CREATE DATABASE IF NOT EXISTS school CHARACTER SET utf8; USE school; CREATE TABLE IF NOT EXISTS Student ( Sno VARCHAR(20) PRIMARY KEY, Sname VARCHAR(50), Ssex VARCHAR(10), Sage INT, Sdept VARCHAR(20) ); CREATE TABLE IF NOT EXISTS Course ( Cno INT PRIMARY KEY, Cname VARCHAR(50), Credit INT ); CREATE TABLE IF NOT EXISTS SC ( Sno VARCHAR(20), Cno INT, Grade FLOAT, FOREIGN KEY (Sno) REFERENCES Student(Sno), FOREIGN KEY (Cno) REFERENCES Course(Cno) ); INSERT INTO Student (Sno, Sname, Ssex, Sage, Sdept) VALUES ('201915121', '李勇', '男', 20, 'XG'), ('201915122', '刘晨', '女', 19, 'GS'), ('201915123', '王敏', '女', 18, 'CJ'), ('201915125', '张立', '男', 19, 'LY'), ('201915129', '王富贵', '男', 17, 'BZ'); INSERT INTO Course (Cno, Cname, Credit) VALUES (1, '数据库', 4), (2, '高等数学', 2), (3, '计算机基础', 4), (4, '操作系统原理', 3), (5, '数据结构', 4), (6, 'Python数据处理', 2), (7, 'Java高级程序设计', 4); INSERT INTO SC (Sno, Cno, Grade) VALUES ('201915121', 1, 90), ('201915121', 2, 86), ('201915121', 3, 88), ('201915122', 2, 91), ('201915122', 3, 59), ('201915129', 3, 49);