MySQL Forums
Forum List  »  MySQL Administrator

Error 1025 error on rename of
Posted by: Jose María Tristán Martín
Date: November 06, 2006 02:03AM


I have a table whith one field "idActividad" that is autonumerique and primary key.
I want change the name of the fiel to "idActividadXCentro", but it send the next error:
ALTER TABLE 'yachar'.'actividadespreventiva' CHANGE COLUMN 'idActividad' 'IdActividadXCentro' INTEGER UNSIGNED NOT NULL DEFAULT 0,
DROP INDEX 'Index_1'
ADD INDEX 'Index_1' USING BTREE('IdActividadXCentro');

MySQL Error Number 1025
Error on rename of '.\yachar\sql-8ac_1' to '.\yachar\actividadespreventiva' (errno: 150)

Thank you very much.

Options: ReplyQuote

Written By
Error 1025 error on rename of
November 06, 2006 02:03AM
November 06, 2006 07:10PM
August 03, 2007 01:54AM
May 15, 2008 09:27AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.