CREATE TABLE `t_test1` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '当更新时自动刷新时间',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时自动填充时间',
`name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;
写2条sql测试一下 :
INSERT INTO t_test1 (`name`) VALUES ('辣鸡xxx1')
UPDATE t_test1 SET `name` = '辣鸡6' where id = 6
搞定啦~