PHP MYSQL DELETE FROM WHERE AND 子句

Question

试图让以下工作正常进行，但我终究无法正常工作。

有人可以帮忙吗？

DELETE FROM 'content' WHERE note_id = '7' AND WHERE userid = '1'
DELETE FROM 'note' WHERE id = '7' AND WHERE userid = '1'

我需要从每个表中删除一条记录，它检查用户是否确实是该用户，但在运行查询时出现语法错误

当我删除第二个 WHERE 时，我收到以下内容。

SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntac to user near 'DELETE FROM note WHERE id ='7' AND userid = '1" at line 2

抱歉，我在脚本到达这里之前添加了一个额外的空格

Answer 1

只需要 1 个WHERE，试试这个:

DELETE FROM content WHERE note_id = '7' AND userid = '1'
DELETE FROM note WHERE id = '7' AND userid = '1'