写一个多表联查加分页查询

var currentPage=(req.query.pagenum - 1) * req.query.pagesize;
//定义查询分类列表数据的sql语句

 const  sql= `
 select *,name as 'cate_name' from   
 ev_articles join ev_article_cate on ev_articles.cate_id = ev_article_cate.id
 where  ev_articles.is_delete=0  order by 	ev_articles.Id  ASC 
 limit ${currentPage} ,${req.query.pagesize}`

版权声明:本文为weixin_45932157原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。