PHWinfo - Afficher un message

15/10/2007, 21h45

Hi,

James Graham wrote:
> 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

Not a clue. Is there a funny character that only looks like a space, or
something of that nature?

15/10/2007, 21h45	#2
Baron Schwartz Messages: n/a Hébergeur:	Re: Error 1064 on a basic UPDATE query Hi, James Graham wrote: > 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 Not a clue. Is there a funny character that only looks like a space, or something of that nature?