CODE EXAMPLE FOR SQL

automatically update database last seen datetime in sql

ALTER TABLE  `test_time` ADD  `dt` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP