Alter Column Name?

2005-06-13 Thread 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 isID, 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

RE: Alter Column Name?

2005-06-13 Thread Rhino
-Original Message- From: Scott Purcell [mailto:[EMAIL PROTECTED] Sent: Monday, June 13, 2005 1:00 PM To: mysql@lists.mysql.com 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

RE: Alter Column Name?

2005-06-13 Thread J.R. Bullington
4:56 PM To: Scott Purcell; mysql@lists.mysql.com Subject: RE: Alter Column Name? 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

Re: Alter Column Name?

2005-06-13 Thread Jigal van Hemert
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 isID, and I would like it to change it to CHILD_ID, as the the software is changing, and we are adding parent_id