Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: James Graham (jamesasperity.co.uk)
Date: Mon Oct 15 2007 - 10:20:58 CDT
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` =
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 :)
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql