At 1:04 PM -0400 9/12/03, [EMAIL PROTECTED] wrote:
...just a shot in the dark, but isn't 'description' a reserved word? If so,
um, maybe a bug/inconsistency between table types. If not, ramble on.
DESC and DESCRIBE are reserved, but DESCRIPTION is not...
--
Paul DuBois, Senior Technical Writer
...just a shot in the dark, but isn't 'description' a reserved word? If so,
um, maybe a bug/inconsistency between table types. If not, ramble on.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
altering a table
From: Irwin Boutboul
Date: Fri, 12 Sep 2003 11:41:29 -0400
I always get that with MySQL 4.1:
alter table ACL_GROUPS add description varchar(255) default 'N/A';
ERROR 1025: Error on rename of './downloadgrid/#sql-1361_1a3' to
'./downloadgrid/ACL_GROUPS
I always get that with MySQL 4.1:
alter table ACL_GROUPS add description varchar(255) default 'N/A';
ERROR 1025: Error on rename of './downloadgrid/#sql-1361_1a3' to
'./downloadgrid/ACL_GROUPS' (errno: 150)
If the table type is MyIsam, it works fine, I can alter the table. However
I can not rev