The reason why I didn't answer this is because I think there is a bug
somewhere. How was a dump file allowed to be created with reserved words?
or better still, how where "illegal" column names allowed to be created in
the first place?
----- Original Message -----
From: "Gerald L. Clark" <[EMAIL PROTECTED]>
To: "Martin" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, February 20, 2001 1:23
Subject: Re: CREATE from a mysqldump won't CREATE a table in 3.23?
> 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
> >
>
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
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
