mysql Invalid default value for

Question

如图

Invalid default value for的原因

Answer 1

查询数据库有什么引擎：
select table_name,`engine` from information_schema.tables where table_schema = 'database_name';

查询表引擎（查看MYISAM）
SELECT CONCAT(table_name,'  ', engine)   FROM information_schema.tables WHERE table_schema="bpm" AND ENGINE="MyISAM";  
生成修改sql（把MYISAM改成INNODB）
select CONCAT('alter table ',table_name,' engine=InnoDB;') FROM information_schema.tables WHERE table_schema="bpm" AND ENGINE="MyISAM";

alter table taai_client_dump_date engine=InnoDB;