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:
: 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
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;
, 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