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
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
