thanx for ur mail, m sorry in dint mention that infact its a big table... Is there a way i can do it in all the columns using only one query ?? thanx 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 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; > +-----------+------------+------+-----+---------+-------+ > | Field | Type | Null | Key | Default | Extra | > +-----------+------------+------+-----+---------+-------+ > | my_file_1 | varchar(5) | YES | | NULL | | > +-----------+------------+------+-----+---------+-------+ > > On Tuesday, July 2, 2002, at 09:36 , Anil Garg wrote: > > > 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 > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
