编辑代码

CREATE DATABASE test;
use test;
CREATE TABLE course (
	cno CHAR(4) ,
    cname VARCHAR(40) ,
    cperiod INT,
    credit DECIMAL(3,1),
    ctno CHAR(4)
);

INSERT INTO course VALUES ('c001','文学欣赏',40,1.5,'t001');
INSERT INTO course VALUES ('c002','中国历史文化',60,2.0,'t003');
INSERT INTO course VALUES ('c003','视频编辑',70,2.5,'t002');
INSERT INTO course VALUES ('c004','音乐欣赏',40,1.5,'t005');
CREATE TABLE teacher(
    tno CHAR(4) ,
    tname VARCHER(10) ,
    tgender CHAR(1) CHECK(tgender='男' or tgender='女'),
    tedu VARCHER(10),
    tpro VARCHAR(8)
);
INSERT INTO teacher
VALUES('t001','吴亚飞','男','本科','讲师'),('t002','李琦','男','硕士研究生','副教授'),('t003','王红艳','女','硕士研究生','讲师')
('t004','马志超','男','博士研究生','教授')('t005','万丽','女','硕士研究生','助理讲师')('t006','张君瑞','男','硕士研究生','副教授')
('t007','赵楠','女','博士研究生','教授');
SELECT *  
FROM course CROSS JOIN teacher;