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
