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

  • Select an option

    Learn more about clone URLs
  • Save mauroartizzu/4713133 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save mauroartizzu/4713133 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. mauroartizzu created this gist Feb 5, 2013.
    7 changes: 7 additions & 0 deletions Mysql created_at updated_at triggers
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,7 @@
    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;