Advanced Search

mysql create modify default timestamp

/ Published in: MySQL
Save to your folder(s)
add created datetime and modified timestamp columns to table

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. ALTER TABLE  `table` ADD  `created` DATETIME NOT NULL ,
  2. ADD  `modified` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP

Report this snippet


Comments

You need to login to view comments.