SELECT COUNT(*) TABLES,
table_schema FROM information_schema.TABLES
WHERE table_schema = 'jgx_chair_sys' GROUP BY table_schema;
写jgx_chair_sys处写成想查询的库名即可,其余地方不需要修改
SELECT COUNT(*) TABLES,
table_schema FROM information_schema.TABLES
WHERE table_schema = 'jgx_chair_sys' GROUP BY table_schema;
写jgx_chair_sys处写成想查询的库名即可,其余地方不需要修改