统计sql，gjjdglj-优快云博客

本文链接：https://blog.youkuaiyun.com/kai402458953/article/details/85246468

本博客提供了从多个数据库表中统计各类药品、医疗器械及化妆品等产品的数量。包括国产和进口产品，涵盖保健食品、特殊用途化妆品、药品、互联网交易服务及信息服...。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

select count(1) ,'国产保健食品' from bjspxy_sfda_gcbjsp
union all
select count(1) ,'国产器械' from bjspxy_sfda_gcqx
union all
select count(1) ,'国产器械历史' from bjspxy_sfda_gcqxlssj
union all
select count(1),'国产特殊用途化妆品' from bjspxy_sfda_gctsythzp
union all
select count(1),'国产药品' from bjspxy_sfda_gcyp
union all
select count(1),'互联网药品交易服务' from bjspxy_sfda_hlwypjyfw
union all
select count(1),'互联网药品信息服务' from bjspxy_sfda_hlwypxxfw
union all
select count(1),'进口保健食品' from bjspxy_sfda_jkbjsp
union all
select count(1),'进口化妆品' from bjspxy_sfda_jkhzp
union all
select count(1),'进口器械' from bjspxy_sfda_jkqx
union all
select count(1),'进口器械历史' from bjspxy_sfda_jkqxlssj
union all
select count(1),'进口药品' from bjspxy_sfda_jkyp
union all
select count(1),'进口药品商品名' from bjspxy_sfda_jkypspm
union all
select count(1) ,'特殊医学用途配方食品' from bjspxy_sfda_tsyxytpfsp
union all
select count(1),'婴幼儿配方乳粉产品配方' from bjspxy_sfda_yyepfrfcppf
union all
select count(1),'网上药店' from bjspyx_sdfa_wsyd
union all
select count(1),'国产药品商品名' from bjspyx_sfda_gcypspm
union all
select count(1),'互联网药品交易服务' from bjspyx_sfda_hlwjyfw
union all
select count(1),'互联网药品信息服务' from bjspyx_sfda_hlwypinfo
union all
select count(1),'婴幼儿配方乳粉产品配方' from bjspyx_sfda_yyepfrf