统计sql，gjjdglj

统计sql，gjjdglj

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