如何在单个查询中删除多个表
问题描述：
这里是我的代码... 删除s。 *，dm。 *来自StaffMaster的内部联接Device_StaffFP dm on s.UserIDN = dm.UserIDN其中s.UserIDN = '19'
当我尝试这样做我有错误...
谢谢..
Here my code...delete s. *, dm. * from StaffMaster s inner join Device_StaffFP dm on s.UserIDN=dm.UserIDN where s.UserIDN='19'
when i try do this i got error...
thank you..
答
你可以使用一个执行此操作的存储过程或您可以使用删除级联外键。
您可以检查类似已解决的问题这里
You can either use a stored procedure for doing this or you can use delete cascade foreign keys.
you can check similar solved question Here
查看此...
单个SQL查询删除两个表中的记录 [ ^ ]
主要用于限制..
希望这会对你有所帮助。
干杯
Hi,
Check this...
Single SQL Query to delete records in two tables[^]
Mainly for Constraints..
Hope this will help you.
Cheers