Re: changing coulmn

>anil >- Original Message - >From: "nellA hciR" <[EMAIL PROTECTED]> >To: "Anil Garg" <[EMAIL PROTECTED]> >Cc: <[EMAIL PROTECTED]> >Sent: Tuesday, July 02, 2002 2:14 PM >Subject: Re: changing coulmn > > >> mysql> create table myt

Re: changing coulmn

lt;[EMAIL PROTECTED]> Sent: Tuesday, July 02, 2002 2:14 PM Subject: Re: changing coulmn > mysql> create table mytest ( > -> my_1 varchar(5) > -> ); > Query OK, 0 rows affected (0.32 sec) > > mysql> alter table mytest change my_1 my_file_1 varchar(5)

Re: changing coulmn

mysql> create table mytest ( -> my_1 varchar(5) -> ); Query OK, 0 rows affected (0.32 sec) mysql> alter table mytest change my_1 my_file_1 varchar(5); Query OK, 0 rows affected (0.23 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> show columns from mytest; +---++

changing coulmn

in my table a column has enties my_1 my_4 my_5 i wnat to change it to my_file_1 my_file_4 my_file_5 can someone please tell me the query for that. thanx anil - Before posting, please check: http://www.mysql.com/manual