com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax；

青旅半醒 2024-04-06 12:22 16阅读 0赞

**报错信息如下**

### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 
    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 '' at line 4

![在这里插入图片描述][9f78efd07c84423f80855659461bc5a8.png]

**报错代码如下：** 使用的mybatis批量新增

![在这里插入图片描述][3c22cb597374472d9dbb6a6982ac19fa.png]

![在这里插入图片描述][d321c804a6e94bf398971f9c2c1b6606.png]

刚开始以为 `Mysql错误:check the manual that corresponds to your MySQL server version for the right syntax` 只要列名加上\`\`就可以，结果还是报错。

仔细检查sql并没有发现问题，后来发现一个问题，报错的时候是因为List传的没有数据导致的错误！

![在这里插入图片描述][62537f528b5d444d8c1e290b570e206b.png]

[9f78efd07c84423f80855659461bc5a8.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/9bacba1b74c84e54af8d81b24b30119e.png
[3c22cb597374472d9dbb6a6982ac19fa.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/92be79c3b7da4a42a70d9a22dab28954.png
[d321c804a6e94bf398971f9c2c1b6606.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/cc8829ac11f9473d8539076c4afe07c6.png
[62537f528b5d444d8c1e290b570e206b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/6aeebd8f098a4584ba2a75bed6d6e84e.png