Thread: error while changing the field name....
View Single Post
  #1  
Old 11-25-2006, 05:10 AM
craily craily is offline
Junior Member
  
Join Date: Nov 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
craily is on a distinguished road
Default error while changing the field name....
Hello there,
A table has one field "idActividad" that is autonumerique and primary key. I need to change the name of the field to "idActividadXCentro", but it send 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');
Any advice please?
Thank you very much. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
  Webmaster Forums - View Single Post - error while changing the field name....
Thread: error while changing the field name....
View Single Post
  #1  
Old 11-25-2006, 05:10 AM
craily craily is offline
Junior Member
  
Join Date: Nov 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
craily is on a distinguished road
Default error while changing the field name....
Hello there,
A table has one field "idActividad" that is autonumerique and primary key. I need to change the name of the field to "idActividadXCentro", but it send 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');
Any advice please?
Thank you very much. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote