当前位置：Gxlcms >
数据库问题 >
Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' 错误解决方案
Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' 错误解决方案
时间：2021-07-01 10:21:17
帮助过：36人阅读
uid, open_acc_status, open_acc_time, mobile_num, email, reg_type
FROM UserInfo
WHERE uid
IN (
SELECT uid
FROM InviteCode
WHERE invite_uid
= 100000004 LIMIT
1 OFFSET
1)
这样的sql语句存在sql语法错误，但是再加一层就行。如：
SELECT uid, open_acc_status, open_acc_time, mobile_num, email, reg_type FROM UserInfo WHERE uid IN (SELECT i.uid FROM (SELECT * FROM InviteCode WHERE invite_uid = 100000004 LIMIT 1 OFFSET 1) as i)
在最后的的from table改成 Select * .
Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' 错误解决方案
标签：str 解决方案 color nbsp 语法错误 status load rom strong
