SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME='컬럼명';
'SQL' 카테고리의 다른 글
| [MySQL] IFNULL, NULLIF (0) | 2020.01.20 |
|---|
[MySQL]컬럼명으로 테이블 찾기
2020. 1. 20. 19:50
SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME='컬럼명';
| [MySQL] IFNULL, NULLIF (0) | 2020.01.20 |
|---|