56,679
社区成员
发帖
与我相关
我的任务
分享
select a.* from tb_te_cour a left join tb_courses b on a.coursename=b.coursename where b.coursename is null;
alter table tb_te_cour add constraint FOREIGN KEY(coursename) REFERENCES tb_courses (coursename) ON DELETE CASCADE ON UPDATE CASCADE