From: "Scott Purcell" > I cannot find any information on this, so I am thinking the answer is no. But I have a column that I would like to change the name of: > > current the column name is"ID", and I would like it to change it to "CHILD_ID", as the the software is changing, and we are adding "parent_id" column.
Answer is yes ;-) For example: ALTER TABLE `tablename` CHANGE `ID` `CHILD_ID` INT(14) NOT NULL DEFAULT '0'; So you must repeat the original column definition after the new name. http://dev.mysql.com/doc/mysql/en/alter-table.html Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
