mp_audio_manage

相关运维sql查询

查询书籍排序重复的问题
select bid,count(*) from chapters WHERE sequence = 1 group by bid having count(bid)>1;

查询书籍完本统计
SELECT COUNT(*), `status` FROM books GROUP BY `status`;