sql 的类型 mysql> update nvc_safecfg set value =1 where key = 'safemode'; ERROR 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 'key = 'safemode'' at line 1 mysql>
试试 update nvc_safecfg set `value` =1 where `key` = 'safemode';
key 换别的也是不行
update nvc_safecfg set `value` =1 where `key` = 'safemode';
mysql> update nvc_safecfg set value =1 where key = 'safemode';
ERROR 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 'key = 'safemode'' at line 1
mysql>
update nvc_safecfg set `value` =1 where `key` = 'safemode';