Check the manual.
"Type" is a reserved word.
"Date" is a reserved word.
Martin wrote:
>
> The following CREATE TABLE came from a mysqldump. When I use the same create
> statement to create the table under mysql 3.23 I get an error:
>
> # MySQL dump 8.12
> #
> # Host: localhost Database: installers
> #--------------------------------------------------------
> # Server version 3.23.32-log
>
> #
> # Table structure for table 'versions'
> #
>
> CREATE TABLE versions (
> file_id int(9) NOT NULL auto_increment,
> languagecode varchar(10) NOT NULL default 'en',
> product varchar(100) NOT NULL default '',
> platform enum('WIN','MAC','LINUX','PALM') NOT NULL default 'WIN',
> version_num varchar(25) NOT NULL default '',
> type enum('BETA','RELEASE') NOT NULL default 'BETA',
> mode enum('PAY','FREE','AD','ALL') NOT NULL default 'PAY',
> date date default NULL,
> size int(9) default NULL,
> expires date default NULL,
> contact_info varchar(255) default NULL,
> ARL varchar(255) default NULL,
> URL varchar(255) default NULL,
> readme varchar(255) default NULL,
> relnotes varchar(255) default NULL,
> whatsnew varchar(255) default NULL,
> note_1 varchar(255) default NULL,
> note_2 varchar(255) default NULL,
> note_3 varchar(255) default NULL,
> note_4 varchar(255) default NULL,
> note_5 varchar(255) default NULL,
> patchURL varchar(255) default NULL,
> patchURLname varchar(255) default NULL,
> patchsize int(9) default NULL,
> patchnote_1 varchar(255) default NULL,
> patchnote_2 varchar(255) default NULL,
> manualURL varchar(255) default NULL,
> manualURLname varchar(255) default NULL,
> manualsize int(9) default NULL,
> manualnote_1 varchar(255) default NULL,
> manualnote_2 varchar(255) default NULL,
> PRIMARY KEY (file_id),
> KEY version(product,platform,version_num)
> ) TYPE=MyISAM;
>
> ERROR 1064 at line 11: You have an error in your SQL syntax near
> 'version(product,platform,version_num)
> ) TYPE=MyISAM' at line 34
>
> What gives and is this a bug? How can it REJECT something it gave me as a
> mysqldump? Curious, isn't it? I believe this is a bug.
>
> Thanks for any info,
>
> Martin
>
