编写mysql时发生错误

这是报错的内容

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 'b,smbms_provider p where b.providerId=p.id and b.providerId=2' at line 1

这是日志所打印出来的SQL语句

SQL语句：delete from smbms_bill b,smbms_provider p where b.providerId=p.id and b.providerId=?
报错内容：Unsafe query: 'Delete' statement without 'where' clears all data in the table

疑问的是我明明有加where为什么会报错呢

看看这个： mysql同时删除多个表中字段_mysql – 从多个字段匹配的表中删除从其他..._山石松的博客-CSDN博客 也许DELETE JOIN会更好DELETE A.* FROM table1 A INNER JOIN table2 bON A.id = B.idAND a.field1 = b.field1AND a.field2 = b.field2AND a.field3 = b.field3AND b.id = ?;我写了为什么DELETE与WHERE涉及一个子查询在2011年2月22日我过去的帖子中... https://blog.csdn.net/weixin_35935712/article/details/113585842