· 8 years ago · Jul 05, 2018, 02:38 PM
1CREATE TABLE IF NOT EXISTS `updated_tables` (
2 `table_name` VARCHAR(50) NOT NULL,
3 `updated_at` TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
4 PRIMARY KEY (`table_name`),
5 UNIQUE INDEX `table_name_UNIQUE` (`table_name` ASC))
6 ENGINE = InnoDB;
7
8INSERT INTO `updated_tables` (`table_name`,`updated_at`) VALUES ('workdamnit',NULL) ON DUPLICATE KEY UPDATE `table_name`=VALUES(`table_name`), `updated_at`=VALUES(`updated_at`);