RE: changing column name

bject: changing column name Hi Can anyone plz give me the query for chaning the column name of an existing table(which does not affect the elements of that column). I hope there is a way to do that. Any help appreciated Thanx Anil -

Re: changing column name

Anil, Thursday, May 30, 2002, 5:36:32 PM, you wrote: AG> Can anyone plz give me the query for chaning the column name of an existing AG> table(which does not affect the elements of that column). AG> I hope there is a way to do that. Use ALTER TABLE to change column name: http://www.mysql.

RE: changing column name

ALTER TABLE tablename CHANGE oldname newname VARCHAR(40) Simon -Original Message- From: Anil Garg [mailto:[EMAIL PROTECTED]] Sent: 30 May 2002 15:37 To: MySql Mail List Subject: changing column name Hi Can anyone plz give me the query for chaning the column name of an existing

changing column name

Hi Can anyone plz give me the query for chaning the column name of an existing table(which does not affect the elements of that column). I hope there is a way to do that. Any help appreciated Thanx Anil - Before posting, ple