016.mysql-判断几张表是否都全部更新,如果全部更新执行以下存储过程

    select 
         sum(c) into cc
         from 
         (
            (select 1 as c from qhdata_warehouse_north_stat.dw_ytb_org_base where occur_period = max_period limit 1 )  
            union all 
            (select 1  as c from qhdata_warehouse_north_stat.dw_ytb_org_statistics where occur_period = max_period limit 1 ) 
        )a;
            

 

posted @ 2020-12-22 11:10  star521  阅读(118)  评论(0编辑  收藏  举报