我的数据库现在是hrdb 我想在这个库里面更新fitdoa库里的t_leave表的一些字段的值 sql语句写成下面这样:update fitdoa.t_leave set state= '1',set approvingofficer=' CZZZZZZZZ',set approvaltime= now(),set comments=' AGREE' where levid= 9执行时报这个错: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 'set a
pprovingofficer=' CZZZZZZZZ',set approvaltime= now(),set comments=' AGREE' ' at
line 1是不是不能这么改?
我表的字段类型是:
+------------------+--------------+------+-----+---------+----------------+
| levid | int(20) | NO | PRI | NULL | auto_increment |
| segname | varchar(100) | YES | | NULL | |
| psegname | varchar(100) | YES | | NULL | |
| staffname | varchar(100) | YES | | NULL | |
| levcatagoriy | varchar(20) | YES | | NULL | |
| apptime | datetime | YES | | NULL | |
| begindate | date | YES | | NULL | |
| enddate | date | YES | | NULL | |
| state | varchar(1) | YES | | NULL | |
| approvingofficer | varchar(20) | YES | | NULL | |
| approvaltime | datetime | YES | | NULL | |
| comments | varchar(200) | YES | | NULL | |
+------------------+--------------+------+-----+---------+----------------+哪位帮我看看 在线等!
corresponds to your MySQL server version for the right syntax to use near 'set a
pprovingofficer=' CZZZZZZZZ',set approvaltime= now(),set comments=' AGREE' ' at
line 1是不是不能这么改?
我表的字段类型是:
+------------------+--------------+------+-----+---------+----------------+
| levid | int(20) | NO | PRI | NULL | auto_increment |
| segname | varchar(100) | YES | | NULL | |
| psegname | varchar(100) | YES | | NULL | |
| staffname | varchar(100) | YES | | NULL | |
| levcatagoriy | varchar(20) | YES | | NULL | |
| apptime | datetime | YES | | NULL | |
| begindate | date | YES | | NULL | |
| enddate | date | YES | | NULL | |
| state | varchar(1) | YES | | NULL | |
| approvingofficer | varchar(20) | YES | | NULL | |
| approvaltime | datetime | YES | | NULL | |
| comments | varchar(200) | YES | | NULL | |
+------------------+--------------+------+-----+---------+----------------+哪位帮我看看 在线等!
解决方案 »
- Server characterset和Db characterset,这俩货之间神马关系?求知道:)
- 求教SQL多表结果如何并列!
- 菜鸟求助贴,也许你不经意的点开就能帮我一个大忙...
- mysql链接不上报错
- 求解 PG sql一条
- 急急急
- 一个关于mySQL jdbc 性能的疑问
- 紧急!!救救我!我已经安装mysql,在mysql>命令下可以建立数据库了,怎么样在delphi中连接???(全力给分)
- 求助mysql表如何批量插入数据
- [求助] 大神们,求帮忙啊,关于MySQL 把数据统计然后动态行显示
- Error Code : 1064 触发器出错如下 急
- mysql触发器 急 在线等待..
set state= '1',set approvingofficer=' CZZZZZZZZ',set approvaltime= now(),set comments=' AGREE'
where levid= 9语法错误,改成如下.
update fitdoa.t_leave
set state= '1',approvingofficer=' CZZZZZZZZ',approvaltime= now(),comments=' AGREE'
where levid= 9
comments=' AGREE' where levid= 9