mysql_列出表中所有字段用逗号做分隔符

select group_concat(`COLUMN_NAME` separator ',')

from information_schema.`COLUMNS`

where TABLE_SCHEMA='promo' and TABLE_NAME='promo_product';