From: Dan Nelson
Date: November 6 2003 5:53pm
Subject: Re: Table Creation
List-Archive: http://lists.mysql.com/mysql/153192
Message-Id: <20031106175326.GH28915@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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