项目中,推广中心要查询推广关系,所有要使用到parent_id这个字段进行查询做假数据测试,原理类似如下:
select category , count(*) AS count from publication_has_category group by category order by count DESC
项目中,推广中心要查询推广关系,所有要使用到parent_id这个字段进行查询做假数据测试,原理类似如下:
select category , count(*) AS count from publication_has_category group by category order by count DESC