查询某个字段在哪个表
SELECT
COLUMN_NAME,
COLUMN_COMMENT,
IS_NULLABLE,
TABLE_SCHEMA,
COLUMN_TYPE,
COLUMN_DEFAULT,
TABLE_NAME
FROM
information_schema.COLUMNS
WHERE
TABLE_SCHEMA = ‘medical_history’
AND COLUMN_COMMENT LIKE ‘%结算方式%’;
查询某个字段在哪个表
最新推荐文章于 2023-04-07 14:27:58 发布