MySQL Forums
Forum List  »  Newbie

reserved words
Posted by: Brian Smith
Date: May 20, 2005 10:04PM

i have a problem here is my syntax:

CREATE TABLE PHPAUCTIONXL_auctionextension ( status enum('enabled','disabled') NOT NULL default 'enabled',
before int(11) NOT NULL default '0',
extend int(11) NOT NULL default '0'
) TYPE=MyISAM;

and i get this error:

#1064 - 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 'before int(11) NOT NULL default '0',
extend int(11) NOT NULL default '0'
) T' at line 2

i know "before" is a reserved word but its the table i have to have and i need it to work so how should i write this.. if possible can you rewrite it exactly how it needs to be thank you so much.... country

Options: ReplyQuote


Subject
Written By
Posted
reserved words
May 20, 2005 10:04PM
May 20, 2005 11:57PM


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.