5 09 2024
1) alter문 생성 SELECT co.table_name ,co.column_name ,co.data_type ,CONCAT(‘alter table ‘ , co.table_name, ‘ CHANGE COLUMN ‘ , co.column_name , ‘ ‘ , co.column_name , ‘ VARCHAR(50) NULL DEFAULT NULL COMMENT “최초 등록자 정보”; ‘) AS ddl FROM information_schema.columns co INNER JOIN information_schema.tables tb ON co.table_schema = tb.table_schema AND co.table_name = tb.table_name AND tb.table_schema = ‘goe_v1_db’ […]