SELECT
ba.*,ba.id as ba_id,bv.*,bv.id as bv_id
FROM
pms_base_attr_info ba,
pms_base_attr_value bv
WHERE
ba.id = bv.attr_id
and
bv.id in (${valueIdStr})
報錯：
### Error querying database. 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 9
### The error may exist in file [F:\yuan\gmall-manage-service\target\classes\mapper\PmsBaseAttrInfoMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT ba.*,ba.id as ba_id,bv.*,bv.id as bv_id FROM pms_base_attr_info ba, pms_base_attr_value bv WHERE ba.id = bv.attr_id and bv.id in
### 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 9
; bad SQL grammar []; nested exception is 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 9, dubbo version: 2.6.0, current host: 127.0.0.1
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/23208.html
標籤：MySQL