I'm not sure if this will work for a column name but there is a CHANGE COLUMN feature in the ALTER TABLE statement so that sounds promising. Then again, I don't have a MySQL system to try it on this week - I am travelling - so I can't be sure if it will work for the column name.
Rhino -----Original Message----- From: Scott Purcell [mailto:[EMAIL PROTECTED] Sent: Monday, June 13, 2005 1:00 PM To: [email protected] Subject: Alter Column Name? 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. Thanks, Scott -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
