MySQL Forums
Forum List  »  Newbie

Error #1166 - Incorrect column name
Posted by: Terry Broughton
Date: December 15, 2005 08:31AM

I'm very new at putting tables in. I followed the documentation on how and what to put in to the table, but receive an error.


CREATE TABLE `ticket` (

`ticketid ` INT( 12 ) NOT NULL AUTO_INCREMENT ,
`uspick1` INT( 5 ) NOT NULL ,
`uspick2` INT( 5 ) NOT NULL ,
`pick1` INT( 5 ) NOT NULL ,
`pick2` INT( 5 ) NOT NULL ,
`pick3` INT( 5 ) NOT NULL ,
`pick4` INT( 5 ) NOT NULL ,
`show1` INT( 1 ) NOT NULL ,
`show2` INT( 1 ) NOT NULL ,
`show3` INT( 1 ) NOT NULL ,
`show4` INT( 1 ) NOT NULL ,
`played` INT( 1 ) NOT NULL ,
`win` INT( 11 ) NOT NULL ,
`email` TEXT NOT NULL ,
`dayt` INT( 2 ) NOT NULL ,
PRIMARY KEY ( `ticketid ` )

) TYPE = MYISAM

MySQL said:

#1166 - Incorrect column name 'ticketid

Could someone help please...Thanks

Options: ReplyQuote


Subject
Written By
Posted
Error #1166 - Incorrect column name
December 15, 2005 08:31AM


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.