You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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 'LIMIT 100' at line 58
#196
Closed
lydialyd0121 opened this issue
Sep 23, 2019
· 1 comment
55 (SELECT b.*
56 FROM um AS b
57 join
58 (select um_no
59 from um_d where license_status ='01' limit 2290010,10) a on a.um_no=b.um_no
时间:2019/9/23 上午10:16:58
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 59
The text was updated successfully, but these errors were encountered:
工单系统执行 sql出现 语法错误,在服务器端及 Navicat 都可以运行成功。
sql如下:
55 (SELECT b.*
56 FROM um AS b
57 join
58 (select um_no
59 from um_d where license_status ='01' limit 2290010,10) a on a.um_no=b.um_no
时间:2019/9/23 上午10:16:58
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 59
The text was updated successfully, but these errors were encountered: