mysql ddl 失败_在mysql中设置列默认值失败

这是我的桌子DDL:-- auto-generated definition

create table treehole

(

id bigint auto_increment

primary key,

content text not null,

author_id bigint not null,

create_time timestamp default CURRENT_TIMESTAMP not null,

modify_time timestamp not null,

oo_num int default 0 not null,

xx_num int default 0 not null

);

create index Treehole_author_id_index

on treehole (author_id);

create index Treehole_create_time_index

on treehole (create_time desc);

create index Treehole_oo_num_index

on treehole (oo_num desc);

并且我想将modify_time的默认值设置为current_timestamp:alter table `treehole`

alter column `modify_time`

set default current_timestamp;

它会发生:[42000][1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'current_timestamp' at line 3

我的MySQL版本是8.0.422