报错提示的语句和我写的mybatis中的语句不一样,不知道怎么个回事儿0.0。
mybatis中sql语句:
SELECT
t.m_id as 'id',
t.name,
t.numbers,
t.s_id as 'spId',
t.learned,
t.learning,
t.plan_finish_date as 'planFinishDate',
t.plan,
t.next_plan as 'nextPlan'
FROM(
SELECT
m.id as 'm_id',
m.name,
m.createdate,
s.numbers,
s.id as 's_id',
s.learned,
s.learning,
s.plan_finish_date ,
s.plan,
s.next_plan
FROM
member AS m
LEFT JOIN study_plan AS s ON m.id = s.m_id
ORDER BY
s.numbers DESC
LIMIT 10000
) t
GROUP BY t.name
ORDER BY t.createdate
我多粘贴了一些报错信息
Error querying database. Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :'
) tmp_count',expect RPAREN, actual EOF tmp_count : select count(1) from (SELECT
t.m_id as 'id',
t.name as 'name',
t.numbers as 'numbers',
t.sp_id as 'spId',
t.learned as 'learned',
t.learning as 'learning',
t.plan_finish_date as 'planFinishDate',
t.plan as 'plan',
t.createdate as 'createdate',
t.next_plan as 'nextPlan'
FROM (
SELECT
m.id as 'm_id',
m.`name`,
m.createdate,
s.numbers,
s.id as 'sp_id',
s.learned,
s.learning,
s.plan_finish_date ,
s.plan,
s.next_plan
FROM
member AS m LEFT JOIN study_plan AS s ON m.id = s.m_id
) tmp_count
### Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :'
) tmp_count',expect RPAREN, actual EOF tmp_count : select count(1) from (SELECT
t.m_id as 'id',
t.name as 'name',
t.numbers as 'numbers',
t.sp_id as 'spId',
t.learned as 'learned',
t.learning as 'learning',
t.plan_finish_date as 'planFinishDate',
t.plan as 'plan',
t.createdate as 'createdate',
t.next_plan as 'nextPlan'
FROM (
SELECT
m.id as 'm_id',
m.`name`,
m.createdate,
s.numbers,
s.id as 'sp_id',
s.learned,
s.learning,
s.plan_finish_date ,
s.plan,
s.next_plan
FROM
member AS m LEFT JOIN study_plan AS s ON m.id = s.m_id
) tmp_count
; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; sql injection violation, syntax error: syntax error, error in :'
) tmp_count',expect RPAREN, actual EOF tmp_count : select count(1) from (SELECT
t.m_id as 'id',
t.name as 'name',
t.numbers as 'numbers',
t.sp_id as 'spId',
t.learned as 'learned',
t.learning as 'learning',
t.plan_finish_date as 'planFinishDate',
t.plan as 'plan',
t.createdate as 'createdate',
t.next_plan as 'nextPlan'
FROM (
SELECT
m.id as 'm_id',
m.`name`,
m.createdate,
s.numbers,
s.id as 'sp_id',
s.learned,
s.learning,
s.plan_finish_date ,
s.plan,
s.next_plan
FROM
member AS m LEFT JOIN study_plan AS s ON m.id = s.m_id
) tmp_count; nested exception is java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :'
) tmp_count',expect RPAREN, actual EOF tmp_count : select count(1) from (SELECT
t.m_id as 'id',
t.name as 'name',
t.numbers as 'numbers',
t.sp_id as 'spId',
t.learned as 'learned',
t.learning as 'learning',
t.plan_finish_date as 'planFinishDate',
t.plan as 'plan',
t.createdate as 'createdate',
t.next_plan as 'nextPlan'
FROM (
SELECT
m.id as 'm_id',
m.`name`,
m.createdate,
s.numbers,
s.id as 'sp_id',
s.learned,
s.learning,
s.plan_finish_date ,
s.plan,
s.next_plan
FROM
member AS m LEFT JOIN study_plan AS s ON m.id = s.m_id
) tmp_count