本文详细介绍了使用SQL语句从数据库中删除特定账户的过程。包括从订单表和账户表中删除与指定账户ID相关的所有记录。
<statement id="DeleteAccount" parameterClass="Account"> BEGIN DELETE FROM ORDERS WHERE ACCOUNT_ID = #Id#; DELETE FROM ACCOUNTS WHERE ACCOUNT_ID = #Id#; END; </statement>
转载于:https://www.cnblogs.com/hwaggLee/p/4484258.html
Ibatis -- 一次执行多条SQL
<statement id="DeleteAccount" parameterClass="Account"> BEGIN DELETE FROM ORDERS WHERE ACCOUNT_ID = #Id#; DELETE FROM ACCOUNTS WHERE ACCOUNT_ID = #Id#; END; </statement>
转载于:https://www.cnblogs.com/hwaggLee/p/4484258.html
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
