update condition 字段报错

最新推荐文章于 2024-02-12 16:53:47 发布

转载最新推荐文章于 2024-02-12 16:53:47 发布 · 885 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/pansidong/p/9134942.html

文章标签：

#数据库 #php

本文介绍了如何正确地使用MySQL更新语句，并通过一个具体的例子解释了为什么在更新语句中使用某些特殊字符如单引号(')会导致语法错误，以及如何避免这类错误。

mysql> update tf_user_present set condition="0" where id=1;
ERROR 1064 (42000): 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 'condition="0" where id=1' at line 1
mysql> update tf_user_present set condition='0' where id=1;
ERROR 1064 (42000): 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 'condition='0' where id=1' at line 1
mysql> mysql> update tf_user_present set `condition`='0' where id=1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

condition是关键字段加``才可以,但加'',这种引号不行

转载于:https://www.cnblogs.com/pansidong/p/9134942.html