List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:November 6 2003 5:53pm
Subject:Re: Table Creation
View as plain text  
In the last episode (Nov 06), Arnoldus Th.J. Koeleman said:
> What is wrong with this table creation
> 
> 
> CREATE TABLE `spid_1__0` (
>   `recordname` varchar(255) NOT NULL default '',
>   `data` enum NOT NULL,

You didn't specify the values for your enum type.  When you post
questions like this, it's a good idea to include the error message you
get also.

ERROR 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 'NOT NULL,
PRIMARY KEY  (`recordname`,`data`)
) TYPE=MyISAM ROW_FORMAT=DYNAMIC'

-- 
	Dan Nelson
	dnelson@stripped
Thread
INNODB flush holdupNihal5 Nov
  • Re: INNODB flush holdupMatt W6 Nov
    • RE: INNODB flush holdupNihal6 Nov
      • Re: INNODB flush holdupJeremy Zawodny6 Nov
        • RE: INNODB flush holdupNihal6 Nov
        • Table CreationArnoldus Th.J. Koeleman6 Nov
          • Re: Table CreationChris Boget6 Nov
          • Re: Table CreationDan Nelson6 Nov
          • Simple question about updating a table fieldAdmin-Stress6 Nov
            • Re: Simple question about updating a table fieldgerald_clark6 Nov