编辑代码

CREATE DATABASE test;
use test;
CREATE TABLE S (
	S# int,
	SNAME varchar(255)
);
/*CREATE TABLE SC (
	S# int,
	C# int
);
CREATE TABLE C (
	CNAME varchar（255）,
	C# int
);*/
INSERT INTO S VALUES (1, '手动');
INSERT INTO S VALUES (2, '法国');
INSERT INTO S VALUES (3, '是到付');
INSERT INTO S VALUES (4, '十大');
INSERT INTO S VALUES (5, '撒大苏打');
INSERT INTO S VALUES (6, '大师大卫');

/*INSERT INTO SC VALUES (1, 1);
INSERT INTO SC VALUES (2, 1);
INSERT INTO SC VALUES (3, 2);
INSERT INTO SC VALUES (4, 1);
INSERT INTO SC VALUES (5, 2);
INSERT INTO SC VALUES (6, 2);

INSERT INTO C VALUES (1, 'MATHS');
INSERT INTO C VALUES (2, 'MATHS');
INSERT INTO C VALUES (3, 'PE');
INSERT INTO C VALUES (4, 'MATHS');
INSERT INTO C VALUES (5, 'PE');
INSERT INTO C VALUES (6, 'PE');*/

SELECT * FROM S;