Doh!
mysql> ALTER TABLE nt_zone_record_log CHANGE COLUMN action action
ENUM('added','modified','deleted','recovered') NOT NULL DEFAULT
'added';
Query OK, 25 rows affected (0.01 sec)
Records: 25 Duplicates: 0 Warnings: 0
Time to squash this bug in MysqlTool
(http://dajoba.com/projects/mysqltool).
--ai
---------- Forwarded message ----------
Date: Tue, 15 May 2001 11:39:44 -0700 (PDT)
From: Abraham Ingersoll <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: alter table change enum set
Can anyone shed light on why this doesn't work, and perhaps tell me how I
can ALTER the enum values .. or is this just not possible?
mysql> ALTER TABLE nt_zone_record_log CHANGE COLUMN action action
ENUM('added','modified','deleted') NOT NULL DEFAULT added;
ERROR 1064: You have an error in your SQL syntax near 'added' at line 1
Thanks,
Abe
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
