Champs DateCreation et DateModification automatiques

Modifié le Sat, 10 Sep 2016 sur 07:16 AM

CREATE TABLE tbExemple (

tsCreated TIMESTAMP DEFAULT CURRENT_TIMESTAMP ,

dtCreated DATETIME DEFAULT CURRENT_TIMESTAMP ,

tsUpdated TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

dtUpdated DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

);