Hi,
I have a table that looks like:
mysql> desc test;
+-----------+---------------+------+-----+---------+-------+
| Field     | Type          | Null | Key | Default | Extra |
+-----------+---------------+------+-----+---------+-------+
| timestamp | timestamp(14) | YES  |     | NULL    |       |
| text      | text          | YES  |     | NULL    |       |
| text2     | varchar(255)  | YES  |     | NULL    |       |
| choose    | enum('y','n') |      |     | y       |       |
+-----------+---------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

I want to change the column choose to ENUM('y', 'n', 'weekly') without
changing the timestamp. How can I do that?

Thanks,
Batara

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to