分类：insert异常

2021
01-09

解决mybatis使用foreach批量insert异常的问题

异常org.springframework.jdbc.BadSqlGrammarException:###Errorupdatingdatabase.Cause:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:YouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourMySQLserverversionfortherightsyntaxtousenear'INSERTINTOt_user_role(userid,roleid)VALUES(1,3);INSERTINTOt_user_ro'atline3###Theerrormayinvolvede... 继续阅读 >