生成脚本往mysql导入数据报错
我自己写了个程序从Excel中读数据生成sql语句,然后用mysql运行,一共1.8W条数据,每次都有200条错误插不进去。
我看了下错误日志,以下是错误:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'insert into `bdt_batch` values('P080818003','报废机械、仪表、办公' at line 1
这条是错误
insert into `bdt_batch` values('P080818003','报废机械、仪表、办公类设备','上海宝钢工贸实业总公司','U02549','李荣根','13801602230','5','2008-08-18 13:41:32','2008-08-21 10:00:00','2008-08-21 09:00:00','','1',null,'','','','',null,'2008-08-21 00:00:00','50000',null,'','',null,'',null,'',null,'0','','','','','','','','','','','','1','HGB');
这条是我的脚本的语句:
insert into `bdt_batch` values('P080818003','报废机械、仪表、办公类设备','上海宝钢工贸实业总公司','U02549','李荣根','13801602230','5','2008-08-18 13:41:32','2008-08-21 10:00:00','2008-08-21 09:00:00','','1',null,'','','','',null,'2008-08-21 00:00:00','50000',null,'','',null,'',null,'',null,'0','','','','','','','','','','','','1','HGB');
这条是我的sql第一条,我把它单独拿出来运行,是不报错的,但是每次运行sql文件就报错,而我也比对了两条sql,一模一样。我把上面这条拿出来运行却报错。