SELECT
SUM(TABLE_ROWS)
FROM
(
SELECT
TABLE_NAME,
TABLE_ROWS
FROM
INFORMATION_SCHEMA.TABLES
WHERE
TABLE_SCHEMA = '数据库名,其他不变'
) t;
效果如下:
SELECT
SUM(TABLE_ROWS)
FROM
(
SELECT
TABLE_NAME,
TABLE_ROWS
FROM
INFORMATION_SCHEMA.TABLES
WHERE
TABLE_SCHEMA = '数据库名,其他不变'
) t;
效果如下: