mysql - 更新mysql中 bool 值的语法

Question

这个问题已经有答案了:

Syntax error due to using a reserved word as a table or column name in MySQL (1 个回答)

已关闭 6 年前。

我尝试更新 MySql 数据库中的 bool 值，但收到错误:

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'add=0, edit=0, delete=0, view=1 where id=3' at line 1

表:温度

DROP TABLE IF EXISTS `struts`.`tempemp`;
CREATE TABLE  `struts`.`tempemp` (
`id` int(10) unsigned NOT NULL auto_increment,
`role` varchar(45) NOT NULL,
`add` tinyint(1) NOT NULL default '0',
`edit` tinyint(1) NOT NULL default '0',
`delete` tinyint(1) NOT NULL default '0',
`view` tinyint(1) NOT NULL default '0',
 PRIMARY KEY  (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

语法:“update tempemp set add=?,edit=?,delete=?,view=? where id=?”;

Answer 1

使用反引号来转义保留字:

 update tempemp set `add`=0, `edit`=0, `delete`=0, `view`=1 where id=3;