解决 MySQL批量插入的问题。
基于MySQL,Navicat,插入数据。批量插入老是有问题。
错误:
[Err] 1064 - 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 `tchfbd` (`tchid`,`tchName`,`period`) VALUES ('21','郭刚','[{"day"' at line 2
然后把insert into语句,加上; 就解决了。(注意最后一个不用分号)