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

    科技2025-10-19  13

    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 索引的占用空间大小(字节)
    Processed: 0.012, SQL: 8