insert_college.sql

来自「一个挺好的招生管理系统」· SQL 代码 · 共 14 行

INSERT INTO COLLEGE VALUES(1001,'清华大学','qinghua',620,5,0);
INSERT INTO COLLEGE VALUES(1002,'北京大学','beijing',600,4,0);
INSERT INTO COLLEGE VALUES(1003,'武汉大学','wuhan',550,6,0);
INSERT INTO COLLEGE VALUES(1004,'华南师范大学','huashi',530,3,0);
INSERT INTO COLLEGE VALUES(1005,'复旦大学','fudan',580,4,0);
INSERT INTO COLLEGE VALUES(1006,'中山大学','zhongda',560,5,0);
	INSERT INTO COLLEGE VALUES(1007,'华南理工大学','huagong',520,4,0);
	INSERT INTO COLLEGE VALUES(1008,'暨南大学','jida',510,3,0);
	INSERT INTO COLLEGE VALUES(1009,'深圳大学','shenda',500,6,0);
	INSERT INTO COLLEGE VALUES(1010,'深圳职业技术学院','shenzhi',450,8,0);

commit;