MySQL创建S,P,J,SPJ表，以及SQL语句

MySQL创建S,P,J,SPJ表

CREATE TABLE S(
	SNO char(9) primary key,
	SNAME char(9),
	STATUS char(9),
	CITY char(9)
);
CREATE TABLE P(
	PNO char(9) primary key,
	PNAME char(9),
	COLOR char(2),
	WEIGHT SMALLINT
);
CREATE TABLE J(
	JNO char(9) primary key,
	JNAME char(9),
	CITY char(9)
);
CREATE TABLE SPJ(
	SNO char(9),
	PNO char(9),
	JNO char(9),
	QTY SMALLINT,
	foreign key (SNO) references S(SNO),
	foreign key (PNO) references P(PNO),
	foreign key (JNO) references J(JNO)
);

INSERT INTO S VALUES ('S1', '精益', '20',