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
When I was flipping pages using take in MySQL, I found that take was invalid, but I was able to use limit
limit queryBuilder
constqueryBuild=this.articleClassifyMapRepository.createQueryBuilder('articleClassifyMap').leftJoinAndSelect(ArticleClassifyEntity,'articleClassify','articleClassify.id = articleClassifyMap.classifyId').select(['count(articleClassifyMap.classifyId) as classifyCount','articleClassify.name as name','articleClassify.tag as tag','articleClassify.id as id']).offset(1).limit(1).groupBy('articleClassifyMap.classifyId')
limit query
SELECTcount(`articleClassifyMap`.`classify_id`) as classifyCount, `articleClassify`.`name`as name, `articleClassify`.`tag`as tag, `articleClassify`.`id`as id FROM`article_classify_map``articleClassifyMap`LEFT JOIN`article_classify``articleClassify`ON`articleClassify`.`id`=`articleClassifyMap`.`classify_id`GROUP BY`articleClassifyMap`.`classify_id`LIMIT1 OFFSET 1
take queryBuilder
constqueryBuild=this.articleClassifyMapRepository.createQueryBuilder('articleClassifyMap').leftJoinAndSelect(ArticleClassifyEntity,'articleClassify','articleClassify.id = articleClassifyMap.classifyId').select(['count(articleClassifyMap.classifyId) as classifyCount','articleClassify.name as name','articleClassify.tag as tag','articleClassify.id as id']).skip(1).take(1).groupBy('articleClassifyMap.classifyId')
take query
SELECTcount(`articleClassifyMap`.`classify_id`) as classifyCount, `articleClassify`.`name`as name, `articleClassify`.`tag`as tag, `articleClassify`.`id`as id FROM`article_classify_map``articleClassifyMap`LEFT JOIN`article_classify``articleClassify`ON`articleClassify`.`id`=`articleClassifyMap`.`classify_id`GROUP BY`articleClassifyMap`.`classify_id`
The text was updated successfully, but these errors were encountered:
When I was flipping pages using take in MySQL, I found that take was invalid, but I was able to use limit
limit queryBuilder
The text was updated successfully, but these errors were encountered: