|
mysql> update zhgstuixiu set q停发时间=20080501 where b个人编号="0000213304";
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 'where b个人编号="0000213304"' at line 1
--------
|Field | Type | Null | Key | Default | Extra |
|a单位编号 | char(8) | YES | | NULL | |
| b个人编号 | char(10) | YES | | NULL | |
| q停发时间 | int(10) | YES | | NULL | |
+---------------+------------+------+-----+---------+-------+
问题补充:不知道语法错在哪儿?
去掉“where ...."条件,
也提示同样错误
------
mysql 5.0.18 for linux |
|