MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: ERROR 1064 (42000)
Posted by: Vinod Sugur
Date: January 12, 2009 02:32AM

Hi Juan,

Yes you are correct the error is because of column name order. The solution is the quote the column using backtick character.

Example:

Select `order` from table1;


Regards,
Vinod Sugur

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
ERROR 1064 (42000)
3187
Juan Salomon
January 02, 2009 11:32AM
Re: ERROR 1064 (42000)
2374
Vinod Sugur
January 12, 2009 02:32AM


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.