DB 설계
-
[MYSQL] DB 테이블 및 컬럼 변경사항 추출 스크립트Physical 2021. 7. 14. 15:33
-- 테이블 select '추가' as type , b.table_schema, b.table_name , a.table_schema, a.table_name from information_schema.tables a left join information_schema.tables b on a.table_name = b.table_name and b.table_schema = 'OLD_DB' where a.table_schema = 'NEW_DB' and b.table_name is null union all select '삭제' as type , b.table_schema, b.table_name , a.table_schema, a.table_name from information_schema.tabl..