SELECT sum(TABLE_ROWS) FROM `information_schema`.`tables` where TABLE_NAME like 'dsj_%' or TABLE_NAME like 'rkk_%' or TABLE_NAME like 'sds_%' or TABLE_NAME like 'sgs_%'
SELECT sum(TABLE_ROWS) FROM `information_schema`.`tables` where TABLE_NAME like 'dsj_%' or TABLE_NAME like 'rkk_%' or TABLE_NAME like 'sds_%' or TABLE_NAME like 'sgs_%'
转载于:https://my.oschina.net/zhangmaoyuan/blog/1982536