mysql timeStamp默认值0000-00-00 00:00:00 报错

步骤一：

set sql_mode=(select replace(@@sql_mode,'NO_ZERO_IN_DATE,NO_ZERO_DATE',''));

步骤二：

ALTER TABLE  数据库表名  ADD COLUMN `end_time ` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '更新时间'  
AFTER  ‘start_time’;