Re: Table Creation

[Chris Boget]

> What is wrong with this table creation
> CREATE TABLE `spid_1__0` (
>   `recordname` varchar(255) NOT NULL default '',
>   `data` enum NOT NULL,
>   PRIMARY KEY  (`recordname`,`data`)
> ) TYPE=MyISAM ROW_FORMAT=DYNAMIC;

What is the specific error you are getting?

W/o knowing that information, I would guess that the query is
dying as you are not specifying the possible values for enum.
But I could be mistaken.

Chris