timestamp类型
DROP table IF EXISTS manager;
create table manager(
id int(11) NOT NULL AUTO_INCREMENT,
phone varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系方式',
status int(11) DEFAULT 0 COMMENT '状态,0:普通用户,1:会员',
insertDate timestamp not null default current_timestamp COMMENT '插入时间',
PRIMARY KEY (`id`) USING BTREE
);
insert into manager (phone) VALUES ('1111');
SELECT * from manager;