@Query(value = "select * from t_sub_forum s where id in (select f.sub_forum_id from t_sub_forum_user f where f.user_id = id ) and s.record_status= 0 and s.theme like '%theme%';",nativeQuery = true)
Page<SubForumEntity> getListByPage(@Param("theme") String theme,@Param("id") long id,
Pageable pageRequest);报错:
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 'order by s.timeStart desc limit 50' at line 1但是我在navicat查询这个语句的时候 就能执行成功
Page<SubForumEntity> getListByPage(@Param("theme") String theme,@Param("id") long id,
Pageable pageRequest);报错:
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 'order by s.timeStart desc limit 50' at line 1但是我在navicat查询这个语句的时候 就能执行成功
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货