SELECT TABLE_SCHEMA AS `資料庫`, TABLE_NAME AS `表名`
FROM information_schema.COLUMNS
WHERE COLUMN_NAME = '欄位名稱';
information_schema.COLUMNS 記錄所有資料庫、表、欄位的元數據。TABLE_SCHEMA = 資料庫名,TABLE_NAME = 表名,COLUMN_NAME = 欄位名。AND TABLE_SCHEMA = 'my_db'。SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, DATA_TYPE, COLUMN_TYPE,
IS_NULLABLE, COLUMN_DEFAULT, COLUMN_KEY, EXTRA, COLUMN_COMMENT
FROM information_schema.COLUMNS
WHERE COLUMN_NAME = '欄位名稱';