Navicat for MySQL导入数据时报错
1:导入的是Excel2007表格格式的数据。2:报错以后数据加进去了。(选择了错误继续执行)3:这个错误对我的数据有影响吗?4:造成这个错误的原因是什么5:这个是日志文...
1:导入的是Excel2007表格格式的数据。
2: 报错以后数据加进去了。(选择了错误继续执行)
3:这个错误对我的数据有影响吗?
4:造成这个错误的原因是什么
5:这个是日志文件
[2012-07-11 13:57:48] [Msg] Import start
[2012-07-11 13:57:48] [Msg] Import type - Excel2007 file
[2012-07-11 13:57:48] [Msg] Import from - D:\SOURCESAFE\数据库初期数据.xlsx
[2012-07-11 13:57:48] [Msg] Import table [CD_ID_MST]
[2012-07-11 13:57:48] [Err] 1406 - Data too long for column 'CD_MST_ID' at row 1
[2012-07-11 13:57:48] [Err] INSERT INTO `CD_ID_MST` (`CD_MST_ID`,`CD_NAME`,`INSERT_USER_ID`,`INSERT_TIME`,`UPDATE_USER_ID`,`UPDATE_TIME`) VALUES ('CD_MST_ID','CD_NAME','INSERT_USER_ID','EE','UPDATE_USER_ID','EE')
[2012-07-11 13:57:48] [Msg] Processed:15, Added:14, Updated:0, Deleted:0, Errors:1
[2012-07-11 13:57:48] [Msg] Finished - Unsuccessfully 展开
2: 报错以后数据加进去了。(选择了错误继续执行)
3:这个错误对我的数据有影响吗?
4:造成这个错误的原因是什么
5:这个是日志文件
[2012-07-11 13:57:48] [Msg] Import start
[2012-07-11 13:57:48] [Msg] Import type - Excel2007 file
[2012-07-11 13:57:48] [Msg] Import from - D:\SOURCESAFE\数据库初期数据.xlsx
[2012-07-11 13:57:48] [Msg] Import table [CD_ID_MST]
[2012-07-11 13:57:48] [Err] 1406 - Data too long for column 'CD_MST_ID' at row 1
[2012-07-11 13:57:48] [Err] INSERT INTO `CD_ID_MST` (`CD_MST_ID`,`CD_NAME`,`INSERT_USER_ID`,`INSERT_TIME`,`UPDATE_USER_ID`,`UPDATE_TIME`) VALUES ('CD_MST_ID','CD_NAME','INSERT_USER_ID','EE','UPDATE_USER_ID','EE')
[2012-07-11 13:57:48] [Msg] Processed:15, Added:14, Updated:0, Deleted:0, Errors:1
[2012-07-11 13:57:48] [Msg] Finished - Unsuccessfully 展开
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询