Re: Table Creation

[Dan Nelson]

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