CREATE TABLE `test` (
`id` INT PRIMARY KEY AUTO_INCREMENT,
`name` VARCHAR(256),
`create_time` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
`update_time` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
)
ALTER table test ADD COLUMN up_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
支持5.7以上版本