sql语句的话,一个事务写三条delete不行麽? delete from USERTYPE where id=1 delete from USERINFO where userTypeId=1 ...
一个事务执行三条删除呗 delete from USERATTACH where userInfoId in(select id from USERATTACH t2,USERINFO t1,USERTYPE t3 where t1.id=t2.userInfoId and t3.id=t1.userTypeId and t3.Id=123) delete from USERINFO where userTypeId=123 delete from USERTYPE where id=123
一个事务写三条delete不行,因为在前台jsp页面传过来只有USERTYPE.id 一个参数
传一个参数可以啊,?就是前台jsp页面传过来只有USERTYPE.id 一个参数,从上向下依次执行,放在一个事物里。 delete from USERATTACH where userInfoId in (select id from USERINFO where userTypeId = ?) ; delete from USERINFO where userTypeId = ?; delete from USERTYPE where id = ?;
delete from USERTYPE where id=1
delete from USERINFO where userTypeId=1
...
delete from USERATTACH where userInfoId in(select id from USERATTACH t2,USERINFO t1,USERTYPE t3 where t1.id=t2.userInfoId
and t3.id=t1.userTypeId and t3.Id=123)
delete from USERINFO where userTypeId=123
delete from USERTYPE where id=123
delete from USERATTACH where userInfoId in (select id from USERINFO where userTypeId = ?) ;
delete from USERINFO where userTypeId = ?;
delete from USERTYPE where id = ?;
我还想问问,我写的那个sql语句为什么出错?我想知道delete为什么不能left join