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]