Mysql table columns into comma-delimited list,mysql table columns comma separated values

Please use the Below code, may it will help you. it is working fine.

Examples:

select group_concat(column_name)
from information_schema.columns
where table_schema = 'XXX' 
and table_name = 'XXX'

Screen Shot: