SELECT
"select count(*) from " || NAME
|| ";" AS cnts
FROM
sqlite_master
WHERE
type = 'table'
**注意:**MySQL中如下:
SELECT
concat
( "select count(*) from ", " ", table_name
, ";" ) AS cnts
FROM
( SELECT table_name
FROM information_schema
.TABLES ) AS new
拓展:
information_schema.tables 视图TABLE_SCHEMA 库名TABLE_NAME 表名ENGINE 引擎TABLE_ROWS 表的行数AVG_ROW_LENGTH 表中行的平均大小(字节)INDEX_LENGTH 索引的占用空间大小(字节)
转载请注明原文地址:https://blackberry.8miu.com/read-41956.html