Champs DateCreation et DateModification automatiques

Modifié le Sam, 10 Sept., 2016 à 7:16 H

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

);