php - 计算由 Codeigniter -> list_tables() 生成的多个表的总行数

Question

需要建议计算我从 Codeigniter list_tables 生成的总行数

$sqlx = $this->db->list_tables();
foreach ($sqlx as $table) { 
$counteachrow = $this->db->count_all($table);
echo $table; | echo $counteachrow; }

//Result for each table
| Name | Count |
-----------------
| TblA |  25   |
| TblB |  25   |
| TblC |  20   |
----------------
Total = 70 //Expected value

我如何从上面给出的代码中得到 Total = 70，非常感谢

标签： phpmysqlcodeignitercountmetadata

Answer 1

您可以使用此查询：

select SUM(table_rows) as 'Count' from information_schema.tables 
where  table_schema='MyDb' AND TABLE_NAME IN ('table1',...)