mysql: removing a timestamps on update CURRENT_TIMESTAMP

This entry was posted by on Monday, 2 August, 2010 at

Situation: you have a table and a timestamp in it. Thee is a on update CURRENT_TIMESTAMP on the column. But you want to get rid of it:

ALTER TABLE yourTable
CHANGE  someCol somecol TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP


Leave a Reply