编辑代码

CREATE DATABASE test;
use test;
CREATE TABLE student (
	xh int,
	cj int,
	bj int,
	bz int
);

INSERT INTO student VALUES (1201,10,12,1);
INSERT INTO student VALUES (1301,20,13,1);

INSERT INTO student VALUES (1302,20,13,0);
INSERT INTO student VALUES (1303,30,13,0);
INSERT INTO student VALUES (1304,40,13,0);
INSERT INTO student VALUES (1305,10,13,0);
INSERT INTO student VALUES (1306, 0,13,0);


INSERT INTO student VALUES (1202,20,12,0);
INSERT INTO student VALUES (1203,30,12,0);
INSERT INTO student VALUES (1204,40,12,0);
INSERT INTO student VALUES (1205,10,12,0);
INSERT INTO student VALUES (1206, 0,12,0);