统计分表数据的总数据量 mysql 5.7

SELECT SUM(TABLE_ROWS) FROM information_schema.tables WHERE table_name REGEXP '^jzgj_input_invoice_[0-9]{1,2}$';

SELECT SUM(TABLE_ROWS) FROM information_schema.tables WHERE table_name REGEXP '^jzgj_output_invoice_[0-9]{1,2}$';