PHWinfo - Afficher un message

15/10/2007, 17h20

Hi List,

We have a transactions table (~600k records). I'm trying a simple update
query, it fails.
I thought this could be due to a reserved word problem, but all names
have been escaped.

mysql> UPDATE `tblTransaction` SET `TYPE` = 'Manual' WHERE (`ORDERID` =
'694215576aac60f10c9eebe4a5a39d0f');
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 'UPDATE `tblTransaction` SET `TYPE` = 'Manual' WHERE
(`ORDERID` = '694215576aac60' at line 1

If anybody has any ideas, please let me know

Thanks, James

15/10/2007, 17h20	#1
James Graham Messages: n/a Hébergeur:	Error 1064 on a basic UPDATE query Hi List, We have a transactions table (~600k records). I'm trying a simple update query, it fails. I thought this could be due to a reserved word problem, but all names have been escaped. mysql> UPDATE `tblTransaction` SET `TYPE` = 'Manual' WHERE (`ORDERID` = '694215576aac60f10c9eebe4a5a39d0f'); 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 'UPDATE `tblTransaction` SET `TYPE` = 'Manual' WHERE (`ORDERID` = '694215576aac60' at line 1 If anybody has any ideas, please let me know Thanks, James