MySQL Forums
Forum List  »  Newbie

1064 error
Posted by: james bush
Date: April 13, 2005 04:34AM

Can anyone tell me what this error means?

MySQL Error
Invalid SQL: UPDATE images SET artist='15', title='Ephemera No.612', desc='2002', medium='Mixed media', size='840 x 840mm', file='bzb3b.jpg', itype='artist' WHERE id='167':
1064 (You have an error in your SQL syntax near 'desc='2002', medium='Mixed media', size='840 x 840mm', file='bzb3b.jpg', itype='' at line 1)


This is the sql:

UPDATE images SET artist='15', title='Ephemera No.612', desc='2002', medium='Mixed media', size='840 x 840mm', file='bzb3b.jpg', itype='artist' WHERE id='167';

i don't see anything wrong. does anyone?
could it be a reserved word problem??

thanks in advance
james

Options: ReplyQuote


Subject
Written By
Posted
1064 error
April 13, 2005 04:34AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.