1、查询数据库中,一个表有多少字段
-- table_schema = '数据库名'
-- table_name = '表名'
SELECT
COUNT(*)
FROM
information_schema.COLUMNS
WHERE table_schema = 'daily'
AND table_name = 'dept' ;
2、已知列名,查找表名
-- COLUMN_NAME LIKE '%id%' 列名的模糊查询
-- table_schema = '数据库名'
SELECT DISTINCT
table_name
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE column_name LIKE '%id%'
AND table_schema = 'daily' ;
3、查找数据库中一共有多少张表
-- table_schema = '数据库名'
SELECT
COUNT(*) TABLES,
table_schema
FROM
information_schema.TABLES
WHERE table_schema = 'ydysjb'
GROUP BY table_schema ;