我的数据库现在是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 | |
+------------------+--------------+------+-----+---------+----------------+哪位帮我看看 在线等!
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