MYSQL 컬럼명으로 테이블 찾기
SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME='컬럼명'; SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE '%컬럼명%'; SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE '%컬럼명%' AND TABLE_SCHEMA='디비명';
개발/SQL
2019. 7. 10. 15:54
공지사항
- Total
- 37,894
- Today
- 59
- Yesterday
- 82
TAG
- 개발자
- 개발
- 소스코드
- 깜빡임
- GOOGLE PLAY
- imagesize
- development
- 안드로이드
- 코드
- Android Studio
- googlemap
- Marker
- zindex
- Google Analytics
- play service
- 코드 넣기
- comma
- Android
- GoogleAnalytics
- 구글맵
- jQuery
- JavaScript
- 마커
- dependencies
- titlebat
- SyntaxHighlighter
- 코드삽입
- imageButton
- Google Map
- 앱