>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
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)
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;
+---++
