Error #1166 - Incorrect column name
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