SELECT
TABLE_NAME,
TABLE_COMMENT
FROM
INFORMATION_SCHEMA.TABLES
WHERE
table_schema = 'nn_bigdata_db'
AND TABLE_COMMENT LIKE '%车队%';
SELECT
table_name,
column_name,
column_comment
FROM
INFORMATION_SCHEMA.`COLUMNS`
WHERE
table_schema = 'nn_bigdata_db' -- AND table_name = 'sys_enterprise'
AND column_comment LIKE '%车队%';
SELECT
table_name,
column_name,
column_comment
FROM
INFORMATION_SCHEMA.`COLUMNS`
WHERE
table_schema = 'passenger'
AND column_name LIKE '%stationCount%';
Mysql查询schema下表的字段、备注、内容
最新推荐文章于 2024-05-06 14:56:43 发布