Error querying database. Cause: com.mysql.jdbc.ex

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   

查看更多关于Error querying database. Cause: com.mysql.jdbc.ex的详细内容...