DB 컬럼 정보 쿼리문으로 가져오기

information_schema.columns 를 사용

SELECT 
	TABLE_NAME, "", COLUMN_NAME, COLUMN_COMMENT, ORDINAL_POSITION, COLUMN_TYPE, COLUMN_KEY, IF(IS_NULLABLE='NO', 'YES', 'NO') AS NOT_NULL, TABLE_SCHEMA
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE TABLE_SCHEMA = 'painting' AND TABLE_NAME ='PA_PLC_FACL_RUN_MES_L';