如何用触发器在JSP中多表删除
我已经建立的触发器 但是还是只删除了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; --------------------编程问答-------------------- 我相問,觸發器不報錯?
where cno=(select cno from deleted這會返回多條結果啊
补充:Java , Web 开发