首页
学习
活动
专区
工具
TVP
发布
社区首页 >问答首页 >错误代码: 1064 mysql 报错??

错误代码: 1064 mysql 报错??

提问于 2020-09-06 12:48:32
回答 0关注 0查看 74

1 queries executed, 0 success, 1 errors, 0 warnings

查询:select dept0_.id as id1_1_0_, dept0_.create_by as create_10_1_0_, dept0_.create_date as create_d2_1_0_, dept0_.pid as pid3_1_0_,...

错误代码: 1064

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 0, 1000' at line 17

执行耗时 : 0 sec

传送时间 : 0 sec

总耗时 : 0.003 sec

这个mysql的语句,为何报错了

SELECT

dept0_.id AS id1_1_0_,

dept0_.create_by AS create_10_1_0_,

dept0_.create_date AS create_d2_1_0_,

dept0_.pid AS pid3_1_0_,

dept0_.pids AS pids4_1_0_,

dept0_.remark AS remark5_1_0_,

dept0_.sort AS sort6_1_0_,

dept0_.status AS status7_1_0_,

dept0_.title AS title8_1_0_,

dept0_.update_by AS update_11_1_0_,

dept0_.update_date AS update_d9_1_0_

FROM

sys_dept dept0_

WHERE dept0_.id = 1

AND (dept0_.status != 3

回答

和开发者交流更多问题细节吧,去 写回答
相关文章

相似问题

相关问答用户
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档