(注:在 SQLite 中用 “||” 符号连接字符串，无法使用concat函数)
    employees
    departments
    dept_emp
    dept_manage
    salaries
    titles
    emp_bonus
    那么就会输出以下的样子:

    cnts
    select count(*) from employees;
    select count(*) from departments;
    select count(*) from dept_emp;
    select count(*) from dept_manager;
    select count(*) from salaries;
    select count(*) from titles;
    select count(*) from emp_bonus;

    解法：
    ①需明确表名存储在哪
    SQLite数据库 SQLITE_MASTER 上执行一个SELECT查询以获得所有表的索引
    CREATE TABLE sqlite_master (
    type TEXT,
    name TEXT,
    tbl_name TEXT,
    rootpage INTEGER,
    sql TEXT
    );
    获取所有表名称 SELECT name FROM sqlite_master WHERE type=’table’ ORDER BY name;
    mysql 存储在information_schema
    select table_name from information_schema.tables

    ②sql
    SQLite数据库
    select “select count(*) from”||name||”;” from sqlite_master where type=’table’
    mysql