Table Create With TimeStamp Column To Show Last Update

The TIMESTAMP column will show when the row was last updated.

CREATE TABLE `TestLastUpdate` (
    `ID` INT NULL,
    `Name` VARCHAR(50) NULL,
    `Address` VARCHAR(50) NULL,
    `LastUpdate` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
)
COMMENT='Last Update'
;

Found a mistake? Have a question or improvement idea? Let me know.

Table Of Contents