试图让以下内容发挥作用,但就我的一生而言,我无法做到这一点。
有人能帮忙吗?
DELETE FROM 'content' WHERE note_id = '7' AND WHERE userid = '1'
DELETE FROM 'note' WHERE id = '7' AND WHERE userid = '1'
我需要从每个表中删除一条记录,它会检查用户是否真的是那个用户,但当我运行查询时会出现语法错误
当我删除第二个WHERE时,我会收到以下内容。
SQL错误(1064):您的SQL语法有错误;检查与您的MySQL服务器版本相对应的手册在'DELETE FROM
note
'WHERE id='7'AND userid='1'附近的用户语法在2号线
很抱歉,在脚本到达这里之前,我添加了一个额外的空间
只需要1个WHERE
,试试这个:
DELETE FROM content WHERE note_id = '7' AND userid = '1'
DELETE FROM note WHERE id = '7' AND userid = '1'
不能在表名周围使用单引号:
DELETE FROM `content` WHERE note_id = '7' AND userid = '1'
您必须在表名和列名周围使用反引号,而不是单引号。
另外:您有两个where
,只需在额外子句之间使用and
即可。
您在一个查询中添加了多个WHERE
子句,这将不起作用。
试试这个:
DELETE FROM content WHERE note_id = '7' AND userid = '1'
DELETE FROM note WHERE id = '7' AND userid = '1'
使用
DELETE FROM 'content' WHERE note_id = '7' AND userid = '1'
DELETE FROM 'note' WHERE id = '7' AND userid = '1'
DELETE FROM content WHERE note_id = '7' AND userid = '1'
DELETE FROM note WHERE id = '7' AND userid = '1'
试试看,有两个错误,"with table and where子句写了两次
"