如果表中已经有数据存在,先将两个字段为null的进行修改
update admin_permissions set created_at = CURRENT_TIMESTAMP,updated_at = CURRENT_TIMESTAMP;
设置自动更新
ALTER TABLE admin_permissions MODIFY created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL;
ALTER TABLE admin_permissions MODIFY updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL;