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
-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
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
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