sql查询
table name : donersreport , register
delete from donersreport inner join register on donersreport.id = register.id where donersreport.id = '12';
我想从两个表中删除数据...
O / P：
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'inner join register
on donersreport.id = register.id where donersreport.id = '12' at line 1
最佳答案
请尝试一下：
Yes you can use join in delete query.
Pl refer the following link for solution.
MYSQL - Delete Query with Join
-
谢谢
关于php - 我如何使用联接查询从两个表中删除行数据？，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/22526392/