1.timestamp类型create table manager(id int not null primary key,mdate timestamp not null default current_timestamp);2.datetime类型create table manager(id int not null primary key,mdate datetime);