如题:
SELECT
TABLE_NAME
FROM
information_schema.`COLUMNS`
WHERE
TABLE_SCHEMA = 'vet(这里是数据库名)'
AND COLUMN_NAME = 'farm_id(这里是字段名)'
查询结果如下:
如题:
SELECT
TABLE_NAME
FROM
information_schema.`COLUMNS`
WHERE
TABLE_SCHEMA = 'vet(这里是数据库名)'
AND COLUMN_NAME = 'farm_id(这里是字段名)'
查询结果如下: