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