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
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
