|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
|
|
|
||||||
 |
|
|
LinkBack | Outils de la discussion |
15/10/2007, 17h20
|
#1 |
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 |
|
|
15/10/2007, 21h45
|
#2 |
|
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? |
|
|
|
| Outils de la discussion | |
|
|
