上传传漏检查SQL

最新推荐文章于 2025-01-15 21:01:22 发布

原创

最新推荐文章于 2025-01-15 21:01:22 发布 · 276 阅读

0 ·

CC 4.0 BY-SA版权

--上传接口监控
  SELECT 'v_erp_gjtc_his' AS tbname, COUNT(*) as num FROM v_erp_gjtc_his UNION ALL
  SELECT 'v_erp_psck' AS tbname, COUNT(*) as num FROM v_erp_psck UNION ALL
  SELECT 'v_erp_psck_his' AS tbname, COUNT(*) as num FROM v_erp_psck_his UNION ALL
  SELECT 'v_erp_qcrk' AS tbname, COUNT(*) as num FROM v_erp_qcrk UNION ALL
  SELECT 'v_erp_qcrk_his' AS tbname, COUNT(*) as num FROM v_erp_qcrk_his UNION ALL
  SELECT 'v_erp_xsck' AS tbname, COUNT(*) as num FROM v_erp_xsck UNION ALL
  SELECT 'v_erp_cgdd' AS tbname, COUNT(*) as num FROM v_erp_cgdd UNION ALL
  SELECT 'v_erp_xsck_his' AS tbname, COUNT(*) as num FROM v_erp_xsck_his UNION ALL
  SELECT 'v_erp_cgdd_his' AS tbname, COUNT(*) as num FROM v_erp_cgdd_his UNION ALL
  SELECT 'v_erp_xsth' AS tbname, COUNT(*) as num FROM v_erp_xsth UNION ALL
  SELECT 'V_ERP_DGRK' AS tbname, COUNT(*) as num FROM V_ERP_DGRK UNION ALL
  SELECT 'V_ERP_DGRK_HIS' AS tbname, COUNT(*) as num FROM V_ERP_DGRK_HIS UNION ALL