Re: Timestamp and alter table

> I want to change the column choose to ENUM('y', 'n', 'weekly') without > changing the timestamp. How can I do that? I tried ALTER TABLE as usual, and it didn't affect the timestamp. Sorry I didn't try this from the beginning :) --Batara -- MySQL General Mailing List For list archives: http:

Timestamp and alter table

Hi, I have a table that looks like: mysql> desc test; +---+---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+---+--+-+-+---+ | timestamp | timestamp(14) | YES | | NULL| | |