牛客SQL练习-49-针对库中的所有表生成select count(*)对应的SQL语句

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 索引的占用空间大小（字节）