CREATE TABLE `mytesttable` (
`id` int(11) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`createtime` datetime DEFAULT CURRENT_TIMESTAMP,
`updatetime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
now() = CURRENT_TIMESTAMP
参考资料:
1、Mysql 设置时间自动生成
https://blog.csdn.net/qq_33096743/article/details/72730127
2、mysql 添加时间列(用于记录创建时间和修改时间)
https://blog.csdn.net/wild46cat/article/details/56843595