Skip to content

Instantly share code, notes, and snippets.

@mauroartizzu

mauroartizzu/Mysql created_at updated_at triggers

Created February 5, 2013 08:51
Show Gist options
  • Star 9 You must be signed in to star a gist
  • Fork 3 You must be signed in to fork a gist
  • Save mauroartizzu/4713133 to your computer and use it in GitHub Desktop.
Save mauroartizzu/4713133 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL created_at updated_at triggers
Raw
Mysql created_at updated_at triggers
ALTER TABLE xxxxxx
ADD created_at TIMESTAMP DEFAULT '0000-00-00 00:00:00',
ADD updated_at TIMESTAMP DEFAULT '0000-00-00 00:00:00';
CREATE TRIGGER xxxxxx_create BEFORE INSERT ON `xxxxxx`
FOR EACH ROW SET NEW.created_at = NOW(), NEW.updated_at = NOW();
CREATE TRIGGER xxxxxx_update BEFORE UPDATE ON `xxxxxx`
FOR EACH ROW SET NEW.updated_at = NOW(), NEW.created_at = OLD.created_at;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment