Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT

导出数据库表语句如下：

mysqldump -u'ifly_ssp'-p'imsp_vcloud' ifly_cpcc_ad_basic T_MEDIA_INFO>/root/database/T_MEDIA_INFO.sql

mysqldump -u'ifly_ssp' -p'imsp_vcloud' ifly_cpcc_ad_basic T_OTHER_PLAT>/root/database/T_OTHER_PLAT.sql

这个是在命令行中输入，不是在mysql中输入

然后在另一个数据库导入

source /home/htling/T_MEDIA_INFO.sql;
报错

查看建表语句如下，发现：

CREATE TABLE `T_MEDIA_INFO` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '媒体ID',
  `NAME` varchar(64) CHARACTER SET utf8 NOT NULL COMMENT '媒体名称',
  `NICKNAME` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '媒体别名',
  `J