How do I alter a mysql table column defaults?

Viewed 84274

I have a table with a column of type timestamp which defaults current_timestamp and updates to current_timestamp on every update.

I want to remove the "on update" feature on this column. How do I write the alter statement?

I tried the following:

ALTER TABLE mytable alter column time  set DEFAULT now();

but this didn't work.

2 Answers
Related