Create Table

[otuatail]

Sorry guys but this is doing my head in. I extracted a table structure from onre database using phpMyadmin. When I try to crate the table on a diffrent database I get an error.

 

MySQL said: 

 

#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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=1' at line 10

 

 

This is the injection

 

CREATE TABLE IF NOT EXISTS `EventsSport` (

  `ID` int(11) NOT NULL auto_increment,

  `Stamp` varchar(14) default NULL,

  `League` char(50) NOT NULL default '',

  `Description` char(50) NOT NULL default '',

  `Channel` char(10) NOT NULL default '',

  `Result` char(10) NOT NULL default '',

  `Visible` char(1) NOT NULL default '',

  PRIMARY KEY  (`ID`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

 

Any ideas

 

Desmond.

 

[PFMaBiSmAd]

The syntax definition in the mysql manual lists CHARACTER SET not CHARSET

 

CHARSET is listed as a synonym for CHARACTER SET, but this is probably version and configuration specific.

[fenway]

If only we knew the mysql version, as is required by the forum posting rules.... :0(