56,938
社区成员




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