I believe that's modify. Check man page.
Alter table yourtablename MODIFY yourfieldname varchar (25) (or whatever
) not null default 'no comment'
-Original Message-
From: Anil Garg [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 30, 2002 7:37 AM
To: MySql Mail List
Subject: changing col
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.
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
table
