Return to Snippet

Revision: 57012
at May 4, 2012 04:34 by navblue


Initial Code
ALTER TABLE  `table` ADD  `created` DATETIME NOT NULL ,
ADD  `modified` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP

Initial URL


Initial Description
add created datetime and modified timestamp columns to table

Initial Title
mysql create modify default timestamp

Initial Tags
mysql

Initial Language
MySQL