Skip to content

Instantly share code, notes, and snippets.

@amatzen

amatzen/snippets_createdandmodified.sql

Last active August 11, 2020 15:14
Show Gist options
  • Save amatzen/784ccdac24161257941e9a5624fd8226 to your computer and use it in GitHub Desktop.
Save amatzen/784ccdac24161257941e9a5624fd8226 to your computer and use it in GitHub Desktop.
Download ZIP
Created and Modified
Raw
snippets_createdandmodified.sql
ALTER TABLE ___
ADD
(
`created_at` DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL,
`modified_at` DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL ON UPDATE CURRENT_TIMESTAMP
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment