MySQL 在 where 子句上给出错误

Question

我正在学习 mysql 的教程，它给了我一个错误，但他没有

UPDATE members SET birthday '2002-01-01'
WHERE `member_id` = 2

我明白了

#1064 - 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 ''2002-01-01' WHERE member_id = 2' at line 1

Answer 1

你错过了你的集合中的 = 符号。试试这个:-

UPDATE members SET birthday = '2002-01-01' WHERE member_id = 2