mysql - 更新 MySQL 查询抛出语法错误

Question

尝试更新 mysql 员工表，其中 Group 列如果包含单词 staff 会将列的内容更改为 4。我做错了什么？

UPDATE employee SET Group = "4" WHERE Group LIKE "Staff";

Answer 1

GROUP 是一个 reserved word .用反引号引用它:

UPDATE employee SET `Group` = "4" WHERE `Group` LIKE "Staff";