teststore
http://rpm.pbone.net/index.php3/stat/4/idpl/28370966/dir/scientific_linux_7/com/glibc-devel-2.17-55.el7.1.i686.rpm.html
rpm --all --query --queryformat "%{NAME}-%{VERSION}-%{RELEASE}-(%{ARCH})\n" | grep glibc
T_XT_ZXT_MENU_JS
T_XT_ZXT_MENU
T_XT_YH_GNJS
T_XT_YHY
T_XT_YH
T_XT_WTTJ
T_XT_PZ
T_XT_OPERATIONLOG
T_XT_JG
T_XT_HCBXX
T_XT_GN_TEMPA
T_XT_GNJS_ZY
T_XT_GNJS
T_XT_GN
T_USER_JBXX
T_TB_NF
T_RW_SHGJ
T_RW_CONTENT_TAB_N2016_4_2_2_2
T_RW_CONTENT_TAB_N2016_2_5_3_T
T_RW_CONTENT_TAB_N2016_2_5_3_2
T_RW_CONTENT_TAB_N2016_2_5_3_1
T_RW_CONTENT_TAB_N2016_2_3_4_2
T_RW_CONTENT_TAB_N2016_2_3_4
T_RW_CONTENT_TAB_N2016_2_3_3_2
T_RW_CONTENT_TAB_N2016_2_3_3_1
T_RW_CONTENT_TAB_N2016_2_3_2
T_RW_CONTENT_TAB_N2016_20_1_2
T_RW_CONTENT_TAB_N2016_18
T_RW_CONTENT_TAB_N2016_17_3
T_RW_CONTENT_TAB_N2016_17_2
T_RW_CONTENT_TAB_N2016_17_1
T_RW_CONTENT_TAB_N2016_16_1
T_RW_CONTENT_TAB_N2016_15_2
T_RW_CONTENT_TAB_N2016_15_1
T_RW_CONTENT_TAB_N2016_14_2
T_RW_CONTENT_TAB_N2016_14_1
T_RW_CONTENT_TAB_N2016_13_2
T_RW_CONTENT_TAB_N2016_13_1
T_RW_CONTENT_TAB_N2016_12_4
T_RW_CONTENT_TAB_N2016_12_3
T_RW_CONTENT_TAB_N2016_12_2
T_RW_CONTENT_TAB_N2016_12_1
T_RW_CONTENT_TAB_N2016_11_7
T_RW_CONTENT_TAB_N2016_11_6
T_RW_CONTENT_TAB_N2016_11_5
T_RW_CONTENT_TAB_N2016_11_4
T_RW_CONTENT_TAB_N2016_11_3
T_RW_CONTENT_TAB_N2016_11_2
T_RW_CONTENT_TAB_N2016_11_1
T_RW_CONTENT_TAB_N2016_10_7
T_RW_CONTENT_TAB_N2016_10_6
T_RW_CONTENT_TAB_N2016_10_5
T_RW_CONTENT_TAB_N2016_10_4
T_RW_CONTENT_TAB_91_1
T_RW_CONTENT_TAB_83_1
T_RW_CONTENT_TAB_542_1
T_RW_CONTENT_TAB_511_5
T_RW_CONTENT_TAB_4_3
T_RW_CONTENT_TAB_3631_3
T_RW_CONTENT_TAB_3631_2
T_RW_CONTENT_TAB_3631_1
T_RW_CONTENT_TAB_352_1
T_RW_CONTENT_TAB_342_1
T_RW_CONTENT_TAB_333_1
T_RW_CONTENT_TAB_332_3
T_RW_CONTENT_TAB_332_2
T_RW_CONTENT_TAB_332_1
T_RW_CONTENT_TAB_331_1
T_RW_CONTENT_TAB_321_1
T_RW_CONTENT_TAB_314_1
T_RW_CONTENT_TAB_313_1
T_RW_CONTENT_TAB_312_1
T_RW_CONTENT_TAB_217_2
T_RW_CONTENT_TAB_217_1
T_RW_CONTENT_TAB_212_1
T_RW_CONTENT_TAB_18_3
T_RW_CONTENT_TAB_18_2
T_RW_CONTENT_TAB_18_1
T_RW_CONTENT_TAB_17_4
T_RW_CONTENT_TAB_17_3
T_RW_CONTENT_TAB_17_2
T_RW_CONTENT_TAB_17_1
T_RW_CONTENT_TAB_1521_1
T_RW_CONTENT_TAB_1461_1
T_RW_CONTENT_TAB_1451_1
T_RW_CONTENT_TAB_13_1
T_RW_CONTENT_TAB_1341_1
T_RW_CONTENT_TAB_1331_1
T_RW_CONTENT_TAB_1321_1
T_RW_CONTENT_TAB_131_5
T_RW_CONTENT_TAB_131_4
T_RW_CONTENT_TAB_131_3
T_RW_CONTENT_TAB_131_2
T_RW_CONTENT_TAB_131_1
T_RW_CONTENT_TAB_11_2
T_RW_CONTENT_TAB_11_1
T_RW_CONTENT_TAB_10_6
T_RW_CONTENT_TAB_10_5
T_RW_CONTENT_TAB_10_4
T_RW_CONTENT_TAB_10_3
T_RW_CONTENT_TAB_10_2
T_RW_CONTENT_TAB_10_1
T_RW_CONTENT_TAB_0_3
T_RW_CONTENT_TAB_0_2
T_RW_CONTENT_TAB_0_1
T_RW_CONTENT
T_RC_FILE
T_RC_CATALOG
T_NB_RW_QZY_FILE
T_NB_RWGJ
T_NB_RW
T_NB_NB_RELEAS
T_NB_NB
T_FZ_NEWS_RELEAS
T_FZ_NEWS
T_DM_XWFBZT
T_DM_XB_NB
T_DM_XB
T_DM_THIRD_SYS
T_DM_SHIFOU
T_DM_NBZT
T_DM_NBRWJB
T_DM_JSSY
T_DM_JGLX
T_DM_GNLX
T_DM_DBRW
T_IM_SEND_LOG
truncate table T_XT_ZXT_MENU_JS;
truncate table T_XT_ZXT_MENU;
truncate table T_XT_YH_GNJS;
truncate table T_XT_YHY;
truncate table T_XT_YH;
truncate table T_XT_WTTJ;
truncate table T_XT_PZ;
truncate table T_XT_OPERATIONLOG;
truncate table T_XT_JG;
truncate table T_XT_HCBXX;
truncate table T_XT_GN_TEMPA;
truncate table T_XT_GNJS_ZY;
truncate table T_XT_GNJS;
truncate table T_XT_GN;
truncate table T_USER_JBXX;
truncate table T_TB_NF;
truncate table T_RW_SHGJ;
truncate table T_RW_CONTENT_TAB_N2016_4_2_2_2;
truncate table T_RW_CONTENT_TAB_N2016_2_5_3_T;
truncate table T_RW_CONTENT_TAB_N2016_2_5_3_2;
truncate table T_RW_CONTENT_TAB_N2016_2_5_3_1;
truncate table T_RW_CONTENT_TAB_N2016_2_3_4_2;
truncate table T_RW_CONTENT_TAB_N2016_2_3_4;
truncate table T_RW_CONTENT_TAB_N2016_2_3_3_2;
truncate table T_RW_CONTENT_TAB_N2016_2_3_3_1;
truncate table T_RW_CONTENT_TAB_N2016_2_3_2;
truncate table T_RW_CONTENT_TAB_N2016_20_1_2;
truncate table T_RW_CONTENT_TAB_N2016_18;
truncate table T_RW_CONTENT_TAB_N2016_17_3;
truncate table T_RW_CONTENT_TAB_N2016_17_2;
truncate table T_RW_CONTENT_TAB_N2016_17_1;
truncate table T_RW_CONTENT_TAB_N2016_16_1;
truncate table T_RW_CONTENT_TAB_N2016_15_2;
truncate table T_RW_CONTENT_TAB_N2016_15_1;
truncate table T_RW_CONTENT_TAB_N2016_14_2;
truncate table T_RW_CONTENT_TAB_N2016_14_1;
truncate table T_RW_CONTENT_TAB_N2016_13_2;
truncate table T_RW_CONTENT_TAB_N2016_13_1;
truncate table T_RW_CONTENT_TAB_N2016_12_4;
truncate table T_RW_CONTENT_TAB_N2016_12_3;
truncate table T_RW_CONTENT_TAB_N2016_12_2;
truncate table T_RW_CONTENT_TAB_N2016_12_1;
truncate table T_RW_CONTENT_TAB_N2016_11_7;
truncate table T_RW_CONTENT_TAB_N2016_11_6;
truncate table T_RW_CONTENT_TAB_N2016_11_5;
truncate table T_RW_CONTENT_TAB_N2016_11_4;
truncate table T_RW_CONTENT_TAB_N2016_11_3;
truncate table T_RW_CONTENT_TAB_N2016_11_2;
truncate table T_RW_CONTENT_TAB_N2016_11_1;
truncate table T_RW_CONTENT_TAB_N2016_10_7;
truncate table T_RW_CONTENT_TAB_N2016_10_6;
truncate table T_RW_CONTENT_TAB_N2016_10_5;
truncate table T_RW_CONTENT_TAB_N2016_10_4;
truncate table T_RW_CONTENT_TAB_91_1;
truncate table T_RW_CONTENT_TAB_83_1;
truncate table T_RW_CONTENT_TAB_542_1;
truncate table T_RW_CONTENT_TAB_511_5;
truncate table T_RW_CONTENT_TAB_4_3;
truncate table T_RW_CONTENT_TAB_3631_3;
truncate table T_RW_CONTENT_TAB_3631_2;
truncate table T_RW_CONTENT_TAB_3631_1;
truncate table T_RW_CONTENT_TAB_352_1;
truncate table T_RW_CONTENT_TAB_342_1;
truncate table T_RW_CONTENT_TAB_333_1;
truncate table T_RW_CONTENT_TAB_332_3;
truncate table T_RW_CONTENT_TAB_332_2;
truncate table T_RW_CONTENT_TAB_332_1;
truncate table T_RW_CONTENT_TAB_331_1;
truncate table T_RW_CONTENT_TAB_321_1;
truncate table T_RW_CONTENT_TAB_314_1;
truncate table T_RW_CONTENT_TAB_313_1;
truncate table T_RW_CONTENT_TAB_312_1;
truncate table T_RW_CONTENT_TAB_217_2;
truncate table T_RW_CONTENT_TAB_217_1;
truncate table T_RW_CONTENT_TAB_212_1;
truncate table T_RW_CONTENT_TAB_18_3;
truncate table T_RW_CONTENT_TAB_18_2;
truncate table T_RW_CONTENT_TAB_18_1;
truncate table T_RW_CONTENT_TAB_17_4;
truncate table T_RW_CONTENT_TAB_17_3;
truncate table T_RW_CONTENT_TAB_17_2;
truncate table T_RW_CONTENT_TAB_17_1;
truncate table T_RW_CONTENT_TAB_1521_1;
truncate table T_RW_CONTENT_TAB_1461_1;
truncate table T_RW_CONTENT_TAB_1451_1;
truncate table T_RW_CONTENT_TAB_13_1;
truncate table T_RW_CONTENT_TAB_1341_1;
truncate table T_RW_CONTENT_TAB_1331_1;
truncate table T_RW_CONTENT_TAB_1321_1;
truncate table T_RW_CONTENT_TAB_131_5;
truncate table T_RW_CONTENT_TAB_131_4;
truncate table T_RW_CONTENT_TAB_131_3;
truncate table T_RW_CONTENT_TAB_131_2;
truncate table T_RW_CONTENT_TAB_131_1;
truncate table T_RW_CONTENT_TAB_11_2;
truncate table T_RW_CONTENT_TAB_11_1;
truncate table T_RW_CONTENT_TAB_10_6;
truncate table T_RW_CONTENT_TAB_10_5;
truncate table T_RW_CONTENT_TAB_10_4;
truncate table T_RW_CONTENT_TAB_10_3;
truncate table T_RW_CONTENT_TAB_10_2;
truncate table T_RW_CONTENT_TAB_10_1;
truncate table T_RW_CONTENT_TAB_0_3;
truncate table T_RW_CONTENT_TAB_0_2;
truncate table T_RW_CONTENT_TAB_0_1;
truncate table T_RW_CONTENT;
truncate table T_RC_FILE;
truncate table T_RC_CATALOG;
truncate table T_NB_RW_QZY_FILE;
truncate table T_NB_RWGJ;
truncate table T_NB_RW;
truncate table T_NB_NB_RELEAS;
truncate table T_NB_NB;
truncate table T_FZ_NEWS_RELEAS;
truncate table T_FZ_NEWS;
truncate table T_DM_XWFBZT;
truncate table T_DM_XB_NB;
truncate table T_DM_XB;
truncate table T_DM_THIRD_SYS;
truncate table T_DM_SHIFOU;
truncate table T_DM_NBZT;
truncate table T_DM_NBRWJB;
truncate table T_DM_JSSY;
truncate table T_DM_JGLX;
truncate table T_DM_GNLX;
truncate table T_DM_DBRW;
truncate table T_IM_SEND_LOG
select * from
(
select count(1) count , 'T_XT_ZXT_MENU_JS' from T_XT_ZXT_MENU_JS union
select count(2) count , 'T_XT_ZXT_MENU' from T_XT_ZXT_MENU union
select count(3) count , 'T_XT_YH_GNJS' from T_XT_YH_GNJS union
select count(4) count , 'T_XT_YHY' from T_XT_YHY union
select count(5) count , 'T_XT_YH' from T_XT_YH union
select count(6) count , 'T_XT_WTTJ' from T_XT_WTTJ union
select count(7) count , 'T_XT_PZ' from T_XT_PZ union
select count(8) count , 'T_XT_OPERATIONLOG' from T_XT_OPERATIONLOG union
select count(9) count , 'T_XT_JG' from T_XT_JG union
select count(10) count , 'T_XT_HCBXX' from T_XT_HCBXX union
select count(11) count , 'T_XT_GN_TEMPA' from T_XT_GN_TEMPA union
select count(12) count , 'T_XT_GNJS_ZY' from T_XT_GNJS_ZY union
select count(13) count , 'T_XT_GNJS' from T_XT_GNJS union
select count(14) count , 'T_XT_GN' from T_XT_GN union
select count(15) count , 'T_USER_JBXX' from T_USER_JBXX union
select count(16) count , 'T_TB_NF' from T_TB_NF union
select count(17) count , 'T_RW_SHGJ' from T_RW_SHGJ union
select count(18) count , 'T_RW_CONTENT_TAB_N2016_4_2_2_2' from T_RW_CONTENT_TAB_N2016_4_2_2_2 union
select count(19) count , 'T_RW_CONTENT_TAB_N2016_2_5_3_T' from T_RW_CONTENT_TAB_N2016_2_5_3_T union
select count(20) count , 'T_RW_CONTENT_TAB_N2016_2_5_3_2' from T_RW_CONTENT_TAB_N2016_2_5_3_2 union
select count(21) count , 'T_RW_CONTENT_TAB_N2016_2_5_3_1' from T_RW_CONTENT_TAB_N2016_2_5_3_1 union
select count(22) count , 'T_RW_CONTENT_TAB_N2016_2_3_4_2' from T_RW_CONTENT_TAB_N2016_2_3_4_2 union
select count(23) count , 'T_RW_CONTENT_TAB_N2016_2_3_4' from T_RW_CONTENT_TAB_N2016_2_3_4 union
select count(24) count , 'T_RW_CONTENT_TAB_N2016_2_3_3_2' from T_RW_CONTENT_TAB_N2016_2_3_3_2 union
select count(25) count , 'T_RW_CONTENT_TAB_N2016_2_3_3_1' from T_RW_CONTENT_TAB_N2016_2_3_3_1 union
select count(26) count , 'T_RW_CONTENT_TAB_N2016_2_3_2' from T_RW_CONTENT_TAB_N2016_2_3_2 union
select count(27) count , 'T_RW_CONTENT_TAB_N2016_20_1_2' from T_RW_CONTENT_TAB_N2016_20_1_2 union
select count(28) count , 'T_RW_CONTENT_TAB_N2016_18' from T_RW_CONTENT_TAB_N2016_18 union
select count(29) count , 'T_RW_CONTENT_TAB_N2016_17_3' from T_RW_CONTENT_TAB_N2016_17_3 union
select count(30) count , 'T_RW_CONTENT_TAB_N2016_17_2' from T_RW_CONTENT_TAB_N2016_17_2 union
select count(31) count , 'T_RW_CONTENT_TAB_N2016_17_1' from T_RW_CONTENT_TAB_N2016_17_1 union
select count(32) count , 'T_RW_CONTENT_TAB_N2016_16_1' from T_RW_CONTENT_TAB_N2016_16_1 union
select count(33) count , 'T_RW_CONTENT_TAB_N2016_15_2' from T_RW_CONTENT_TAB_N2016_15_2 union
select count(34) count , 'T_RW_CONTENT_TAB_N2016_15_1' from T_RW_CONTENT_TAB_N2016_15_1 union
select count(35) count , 'T_RW_CONTENT_TAB_N2016_14_2' from T_RW_CONTENT_TAB_N2016_14_2 union
select count(36) count , 'T_RW_CONTENT_TAB_N2016_14_1' from T_RW_CONTENT_TAB_N2016_14_1 union
select count(37) count , 'T_RW_CONTENT_TAB_N2016_13_2' from T_RW_CONTENT_TAB_N2016_13_2 union
select count(38) count , 'T_RW_CONTENT_TAB_N2016_13_1' from T_RW_CONTENT_TAB_N2016_13_1 union
select count(39) count , 'T_RW_CONTENT_TAB_N2016_12_4' from T_RW_CONTENT_TAB_N2016_12_4 union
select count(40) count , 'T_RW_CONTENT_TAB_N2016_12_3' from T_RW_CONTENT_TAB_N2016_12_3 union
select count(41) count , 'T_RW_CONTENT_TAB_N2016_12_2' from T_RW_CONTENT_TAB_N2016_12_2 union
select count(42) count , 'T_RW_CONTENT_TAB_N2016_12_1' from T_RW_CONTENT_TAB_N2016_12_1 union
select count(43) count , 'T_RW_CONTENT_TAB_N2016_11_7' from T_RW_CONTENT_TAB_N2016_11_7 union
select count(44) count , 'T_RW_CONTENT_TAB_N2016_11_6' from T_RW_CONTENT_TAB_N2016_11_6 union
select count(45) count , 'T_RW_CONTENT_TAB_N2016_11_5' from T_RW_CONTENT_TAB_N2016_11_5 union
select count(46) count , 'T_RW_CONTENT_TAB_N2016_11_4' from T_RW_CONTENT_TAB_N2016_11_4 union
select count(47) count , 'T_RW_CONTENT_TAB_N2016_11_3' from T_RW_CONTENT_TAB_N2016_11_3 union
select count(48) count , 'T_RW_CONTENT_TAB_N2016_11_2' from T_RW_CONTENT_TAB_N2016_11_2 union
select count(49) count , 'T_RW_CONTENT_TAB_N2016_11_1' from T_RW_CONTENT_TAB_N2016_11_1 union
select count(50) count , 'T_RW_CONTENT_TAB_N2016_10_7' from T_RW_CONTENT_TAB_N2016_10_7 union
select count(51) count , 'T_RW_CONTENT_TAB_N2016_10_6' from T_RW_CONTENT_TAB_N2016_10_6 union
select count(52) count , 'T_RW_CONTENT_TAB_N2016_10_5' from T_RW_CONTENT_TAB_N2016_10_5 union
select count(53) count , 'T_RW_CONTENT_TAB_N2016_10_4' from T_RW_CONTENT_TAB_N2016_10_4 union
select count(54) count , 'T_RW_CONTENT_TAB_91_1' from T_RW_CONTENT_TAB_91_1 union
select count(55) count , 'T_RW_CONTENT_TAB_83_1' from T_RW_CONTENT_TAB_83_1 union
select count(56) count , 'T_RW_CONTENT_TAB_542_1' from T_RW_CONTENT_TAB_542_1 union
select count(57) count , 'T_RW_CONTENT_TAB_511_5' from T_RW_CONTENT_TAB_511_5 union
select count(58) count , 'T_RW_CONTENT_TAB_4_3' from T_RW_CONTENT_TAB_4_3 union
select count(59) count , 'T_RW_CONTENT_TAB_3631_3' from T_RW_CONTENT_TAB_3631_3 union
select count(60) count , 'T_RW_CONTENT_TAB_3631_2' from T_RW_CONTENT_TAB_3631_2 union
select count(61) count , 'T_RW_CONTENT_TAB_3631_1' from T_RW_CONTENT_TAB_3631_1 union
select count(62) count , 'T_RW_CONTENT_TAB_352_1' from T_RW_CONTENT_TAB_352_1 union
select count(63) count , 'T_RW_CONTENT_TAB_342_1' from T_RW_CONTENT_TAB_342_1 union
select count(64) count , 'T_RW_CONTENT_TAB_333_1' from T_RW_CONTENT_TAB_333_1 union
select count(65) count , 'T_RW_CONTENT_TAB_332_3' from T_RW_CONTENT_TAB_332_3 union
select count(66) count , 'T_RW_CONTENT_TAB_332_2' from T_RW_CONTENT_TAB_332_2 union
select count(67) count , 'T_RW_CONTENT_TAB_332_1' from T_RW_CONTENT_TAB_332_1 union
select count(68) count , 'T_RW_CONTENT_TAB_331_1' from T_RW_CONTENT_TAB_331_1 union
select count(69) count , 'T_RW_CONTENT_TAB_321_1' from T_RW_CONTENT_TAB_321_1 union
select count(70) count , 'T_RW_CONTENT_TAB_314_1' from T_RW_CONTENT_TAB_314_1 union
select count(71) count , 'T_RW_CONTENT_TAB_313_1' from T_RW_CONTENT_TAB_313_1 union
select count(72) count , 'T_RW_CONTENT_TAB_312_1' from T_RW_CONTENT_TAB_312_1 union
select count(73) count , 'T_RW_CONTENT_TAB_217_2' from T_RW_CONTENT_TAB_217_2 union
select count(74) count , 'T_RW_CONTENT_TAB_217_1' from T_RW_CONTENT_TAB_217_1 union
select count(75) count , 'T_RW_CONTENT_TAB_212_1' from T_RW_CONTENT_TAB_212_1 union
select count(76) count , 'T_RW_CONTENT_TAB_18_3' from T_RW_CONTENT_TAB_18_3 union
select count(77) count , 'T_RW_CONTENT_TAB_18_2' from T_RW_CONTENT_TAB_18_2 union
select count(78) count , 'T_RW_CONTENT_TAB_18_1' from T_RW_CONTENT_TAB_18_1 union
select count(79) count , 'T_RW_CONTENT_TAB_17_4' from T_RW_CONTENT_TAB_17_4 union
select count(80) count , 'T_RW_CONTENT_TAB_17_3' from T_RW_CONTENT_TAB_17_3 union
select count(81) count , 'T_RW_CONTENT_TAB_17_2' from T_RW_CONTENT_TAB_17_2 union
select count(82) count , 'T_RW_CONTENT_TAB_17_1' from T_RW_CONTENT_TAB_17_1 union
select count(83) count , 'T_RW_CONTENT_TAB_1521_1' from T_RW_CONTENT_TAB_1521_1 union
select count(84) count , 'T_RW_CONTENT_TAB_1461_1' from T_RW_CONTENT_TAB_1461_1 union
select count(85) count , 'T_RW_CONTENT_TAB_1451_1' from T_RW_CONTENT_TAB_1451_1 union
select count(86) count , 'T_RW_CONTENT_TAB_13_1' from T_RW_CONTENT_TAB_13_1 union
select count(87) count , 'T_RW_CONTENT_TAB_1341_1' from T_RW_CONTENT_TAB_1341_1 union
select count(88) count , 'T_RW_CONTENT_TAB_1331_1' from T_RW_CONTENT_TAB_1331_1 union
select count(89) count , 'T_RW_CONTENT_TAB_1321_1' from T_RW_CONTENT_TAB_1321_1 union
select count(90) count , 'T_RW_CONTENT_TAB_131_5' from T_RW_CONTENT_TAB_131_5 union
select count(91) count , 'T_RW_CONTENT_TAB_131_4' from T_RW_CONTENT_TAB_131_4 union
select count(92) count , 'T_RW_CONTENT_TAB_131_3' from T_RW_CONTENT_TAB_131_3 union
select count(93) count , 'T_RW_CONTENT_TAB_131_2' from T_RW_CONTENT_TAB_131_2 union
select count(94) count , 'T_RW_CONTENT_TAB_131_1' from T_RW_CONTENT_TAB_131_1 union
select count(95) count , 'T_RW_CONTENT_TAB_11_2' from T_RW_CONTENT_TAB_11_2 union
select count(96) count , 'T_RW_CONTENT_TAB_11_1' from T_RW_CONTENT_TAB_11_1 union
select count(97) count , 'T_RW_CONTENT_TAB_10_6' from T_RW_CONTENT_TAB_10_6 union
select count(98) count , 'T_RW_CONTENT_TAB_10_5' from T_RW_CONTENT_TAB_10_5 union
select count(99) count , 'T_RW_CONTENT_TAB_10_4' from T_RW_CONTENT_TAB_10_4 union
select count(100) count , 'T_RW_CONTENT_TAB_10_3' from T_RW_CONTENT_TAB_10_3 union
select count(101) count , 'T_RW_CONTENT_TAB_10_2' from T_RW_CONTENT_TAB_10_2 union
select count(102) count , 'T_RW_CONTENT_TAB_10_1' from T_RW_CONTENT_TAB_10_1 union
select count(103) count , 'T_RW_CONTENT_TAB_0_3' from T_RW_CONTENT_TAB_0_3 union
select count(104) count , 'T_RW_CONTENT_TAB_0_2' from T_RW_CONTENT_TAB_0_2 union
select count(105) count , 'T_RW_CONTENT_TAB_0_1' from T_RW_CONTENT_TAB_0_1 union
select count(106) count , 'T_RW_CONTENT' from T_RW_CONTENT union
select count(107) count , 'T_RC_FILE' from T_RC_FILE union
select count(108) count , 'T_RC_CATALOG' from T_RC_CATALOG union
select count(109) count , 'T_NB_RW_QZY_FILE' from T_NB_RW_QZY_FILE union
select count(110) count , 'T_NB_RWGJ' from T_NB_RWGJ union
select count(111) count , 'T_NB_RW' from T_NB_RW union
select count(112) count , 'T_NB_NB_RELEAS' from T_NB_NB_RELEAS union
select count(113) count , 'T_NB_NB' from T_NB_NB union
select count(114) count , 'T_FZ_NEWS_RELEAS' from T_FZ_NEWS_RELEAS union
select count(115) count , 'T_FZ_NEWS' from T_FZ_NEWS union
select count(116) count , 'T_DM_XWFBZT' from T_DM_XWFBZT union
select count(117) count , 'T_DM_XB_NB' from T_DM_XB_NB union
select count(118) count , 'T_DM_XB' from T_DM_XB union
select count(119) count , 'T_DM_THIRD_SYS' from T_DM_THIRD_SYS union
select count(120) count , 'T_DM_SHIFOU' from T_DM_SHIFOU union
select count(121) count , 'T_DM_NBZT' from T_DM_NBZT union
select count(122) count , 'T_DM_NBRWJB' from T_DM_NBRWJB union
select count(123) count , 'T_DM_JSSY' from T_DM_JSSY union
select count(124) count , 'T_DM_JGLX' from T_DM_JGLX union
select count(125) count , 'T_DM_GNLX' from T_DM_GNLX union
select count(126) count , 'T_DM_DBRW' from T_DM_DBRW union
select count(127) count , 'T_IM_SEND_LOG' from T_IM_SEND_LOG
);
0 T_IM_SEND_LOG
0 T_RW_CONTENT_TAB_3631_1
0 T_RW_CONTENT_TAB_3631_2
0 T_RW_CONTENT_TAB_3631_3
0 T_XT_HCBXX
1 T_NB_RW_QZY_FILE
1 T_RW_CONTENT_TAB_N2016_10_7
1 T_RW_CONTENT_TAB_N2016_11_1
1 T_RW_CONTENT_TAB_N2016_11_2
1 T_RW_CONTENT_TAB_N2016_11_3
1 T_RW_CONTENT_TAB_N2016_11_4
COUNT 'T_XT_ZXT_MENU_JS'
---------- ------------------------------
1 T_RW_CONTENT_TAB_N2016_11_5
1 T_RW_CONTENT_TAB_N2016_11_6
1 T_RW_CONTENT_TAB_N2016_11_7
1 T_RW_CONTENT_TAB_N2016_12_1
1 T_RW_CONTENT_TAB_N2016_12_2
1 T_RW_CONTENT_TAB_N2016_12_3
1 T_RW_CONTENT_TAB_N2016_12_4
1 T_RW_CONTENT_TAB_N2016_13_1
1 T_RW_CONTENT_TAB_N2016_13_2
1 T_RW_CONTENT_TAB_N2016_15_1
1 T_RW_CONTENT_TAB_N2016_15_2
COUNT 'T_XT_ZXT_MENU_JS'
---------- ------------------------------
1 T_RW_CONTENT_TAB_N2016_17_1
1 T_RW_CONTENT_TAB_N2016_17_3
1 T_RW_CONTENT_TAB_N2016_20_1_2
1 T_RW_CONTENT_TAB_N2016_2_3_2
1 T_RW_CONTENT_TAB_N2016_2_3_3_1
1 T_RW_CONTENT_TAB_N2016_2_3_3_2
1 T_RW_CONTENT_TAB_N2016_2_3_4
1 T_RW_CONTENT_TAB_N2016_2_5_3_1
1 T_RW_CONTENT_TAB_N2016_2_5_3_2
1 T_RW_CONTENT_TAB_N2016_2_5_3_T
1 T_RW_CONTENT_TAB_N2016_4_2_2_2
COUNT 'T_XT_ZXT_MENU_JS'
---------- ------------------------------
1 T_XT_PZ
1 T_XT_WTTJ
2 T_DM_DBRW
2 T_DM_GNLX
2 T_DM_SHIFOU
2 T_DM_XB_NB
2 T_RW_CONTENT_TAB_17_2
2 T_RW_CONTENT_TAB_N2016_10_6
2 T_RW_CONTENT_TAB_N2016_14_2
2 T_RW_CONTENT_TAB_N2016_17_2
2 T_RW_CONTENT_TAB_N2016_2_3_4_2
COUNT 'T_XT_ZXT_MENU_JS'
---------- ------------------------------
3 T_DM_THIRD_SYS
3 T_DM_XB
3 T_DM_XWFBZT
3 T_RW_CONTENT_TAB_1461_1
3 T_RW_CONTENT_TAB_511_5
3 T_RW_CONTENT_TAB_N2016_16_1
4 T_DM_JSSY
4 T_DM_NBRWJB
4 T_DM_NBZT
4 T_RW_CONTENT_TAB_10_6
4 T_RW_CONTENT_TAB_131_4
COUNT 'T_XT_ZXT_MENU_JS'
---------- ------------------------------
4 T_RW_CONTENT_TAB_1331_1
4 T_RW_CONTENT_TAB_N2016_10_5
4 T_RW_CONTENT_TAB_N2016_14_1
4 T_RW_CONTENT_TAB_N2016_18
4 T_TB_NF
4 T_XT_YHY
5 T_RW_CONTENT_TAB_0_1
5 T_RW_CONTENT_TAB_0_3
5 T_RW_CONTENT_TAB_1321_1
5 T_RW_CONTENT_TAB_1341_1
5 T_RW_CONTENT_TAB_542_1
COUNT 'T_XT_ZXT_MENU_JS'
---------- ------------------------------
5 T_RW_CONTENT_TAB_N2016_10_4
5 T_XT_YH_GNJS
6 T_RW_CONTENT_TAB_0_2
6 T_RW_CONTENT_TAB_10_2
6 T_RW_CONTENT_TAB_131_5
6 T_RW_CONTENT_TAB_321_1
7 T_RW_CONTENT_TAB_17_1
7 T_RW_CONTENT_TAB_332_1
7 T_RW_CONTENT_TAB_333_1
7 T_RW_CONTENT_TAB_91_1
8 T_DM_JGLX
COUNT 'T_XT_ZXT_MENU_JS'
---------- ------------------------------
9 T_RC_CATALOG
9 T_RW_CONTENT_TAB_10_4
9 T_RW_CONTENT_TAB_1451_1
9 T_RW_CONTENT_TAB_332_3
10 T_RW_CONTENT_TAB_10_3
10 T_RW_CONTENT_TAB_313_1
11 T_RW_CONTENT_TAB_17_4
11 T_RW_CONTENT_TAB_212_1
11 T_RW_CONTENT_TAB_312_1
11 T_RW_CONTENT_TAB_314_1
11 T_RW_CONTENT_TAB_332_2
COUNT 'T_XT_ZXT_MENU_JS'
---------- ------------------------------
11 T_XT_GNJS
12 T_RW_CONTENT_TAB_10_5
14 T_FZ_NEWS
14 T_RW_CONTENT_TAB_131_2
14 T_RW_CONTENT_TAB_131_3
15 T_RW_CONTENT_TAB_10_1
15 T_RW_CONTENT_TAB_17_3
15 T_RW_CONTENT_TAB_18_1
15 T_RW_CONTENT_TAB_18_2
16 T_NB_RWGJ
16 T_RW_CONTENT_TAB_18_3
COUNT 'T_XT_ZXT_MENU_JS'
---------- ------------------------------
17 T_RW_CONTENT_TAB_83_1
18 T_RW_CONTENT_TAB_131_1
18 T_USER_JBXX
20 T_RW_CONTENT_TAB_11_1
20 T_RW_CONTENT_TAB_11_2
20 T_RW_CONTENT_TAB_331_1
21 T_RW_CONTENT_TAB_13_1
24 T_RW_CONTENT_TAB_217_1
24 T_RW_CONTENT_TAB_217_2
27 T_RW_CONTENT_TAB_352_1
30 T_RW_CONTENT_TAB_4_3
COUNT 'T_XT_ZXT_MENU_JS'
---------- ------------------------------
33 T_RW_CONTENT_TAB_1521_1
35 T_XT_GN
39 T_RW_CONTENT_TAB_342_1
40 T_XT_GN_TEMPA
95 T_NB_NB
122 T_XT_ZXT_MENU
156 T_XT_JG
501 T_XT_GNJS_ZY
672 T_XT_YH
896 T_FZ_NEWS_RELEAS
1318 T_RW_SHGJ
COUNT 'T_XT_ZXT_MENU_JS'
---------- ------------------------------
1389 T_XT_ZXT_MENU_JS
1394 T_RW_CONTENT
4252 T_NB_RW
4626 T_RC_FILE
4789 T_NB_NB_RELEAS
5470 T_XT_OPERATIONLOG
上一篇： linux tail 查看日志文件方法
下一篇： 黑莓发公开信：我们仍将继续运营