MariaDB

Change timestamp on update and insert

ALTER TABLE <table name>
CHANGE  
 `<column name>` datetime
TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

Revision #1
Created 1 August 2021 19:19:11 by Max
Updated 1 August 2021 19:20:24 by Max