Live Brilliant

1. 기본적으로 컬럼명을 알고 싶다면 SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='wseCRM' AND TABLE_NAME='CRM_MEMBER_INFO'; 결과 COLUMN_NAME NO NAME PHONE ZCODE 2. 코드에서 사용할 배열값이 필요할때 SELECT group_concat(COLUMN_NAME) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'wseCRM' AND TABLE_NAME = 'CRM_MEMBER_INFO'; 결과 => NO, NAME, PHONE, ZCODE, ADDR