MYSQL specifies the number of rows in all tables in the database query _ MySQL

MYSQL specifies the number of rows in all tables in the database query bitsCN.com

MYSQL specifies the number of rows in all tables in the database.

[SQL] SELECT CONCAT ('Union all select ''', TABLE_SCHEMA, ''' as db, ''', TABLE_NAME, ''' as tbname, count (1) as rows from ', TABLE_SCHEMA ,'. ', TABLE_NAME) AS SqlExe FROM information_schema.TABLES AS t WHERE t. TABLE_TYPE = 'base table' AND t. TABLE_SCHEMA = 'addatacenter'

-- Mysql data statistics are inaccurate when you directly access the view.

BitsCN.com