One of the tricky things about finding errors is that the error is often
earlier than you expect. Mysql points out where it stopped understanding
you, but often it's due to something on the line before. That's the case
here. There's nothing wrong with your ENUM, but the previous line says you
want to set a DEFAULT for column Feature, but you don't provide a value.
You need to either provide the default value or drop the word DEFAULT. The
same thing applies to columns Owner and NewFeatureDescription.
Michael
Bartis, Robert M (Bob) wrote:
I created the dump file from my current DB to make adjustments and also migrate to Innodb tables. In the process I have tried to add some ENUM types in select table. Obviously, I am doing something wrong as each one give me a syntax error 1064 when I try to source in the text file. I've read the manual and do not see where my error is. Can someone point out what is wrong on the below table?
Thanks in advance
Bob
-- MySQL dump 9.10
--
-- Host: bartis-1 Database: stingertrdb4
-- ------------------------------------------------------
-- Server version 4.0.18-max-debug
--
-- Table structure for table `feature_list`
--
DROP TABLE IF EXISTS feature_list;
CREATE TABLE feature_list (
Feature varchar(50) default NOT NULL,
New ENUM('Y','N') NOT NULL,
Owner varchar(50) default NOT NULL,
NewFeatureDescription varchar(255) default NOT NULL,
DateMod datetime NOT NULL default 'YYYY-MM-DD HH:MM:SS',
PRIMARY KEY Feature (Feature),
INDEX Owner (Owner),
FOREIGN KEY (Owner) REFERENCES tester_list(Tester) ON UPDATE CASCADE ON DELETE RESTRICT
) TYPE=InnoDB;
Robert M. Bartis
Lucent Technologies ¢
Room HO 1C-413A (HO) / 1B-304 (WH)
( 732.949.4565 (HO) / 973.386.7426 (WH)
* [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
