Skip to content

Timestamp columns… when phpMyAdmin won’t let you change defaults!

by moflint on November 16th, 2011
ALTER TABLE my_table CHANGE created created TIMESTAMP NOT NULL DEFAULT 0, CHANGE modified modified TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL

From → Odds

No comments yet

Leave a Reply

Note: XHTML is allowed. Your email address will never be published.

Subscribe to this comment feed via RSS