我已经建立的触发器 但是还是只删除了TeacherCourse的内容 没有删除Course表中相应的内容
String sql2="create trigger del on TeacherCourse for delete as delete from Course where cno=(select cno from deleted);end;";
String sql="delete from TeacherCourse where TeacherCourse.cno="+cno;
String sql2="create trigger del on TeacherCourse for delete as delete from Course where cno=(select cno from deleted);end;";
String sql="delete from TeacherCourse where TeacherCourse.cno="+cno;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货