select group_concat(`COLUMN_NAME` separator ',')
from information_schema.`COLUMNS`
where TABLE_SCHEMA='promo' and TABLE_NAME='promo_product';
select group_concat(`COLUMN_NAME` separator ',')
from information_schema.`COLUMNS`
where TABLE_SCHEMA='promo' and TABLE_NAME='promo_product';
转载于:https://www.cnblogs.com/yinzhenyuan/archive/2013/06/03/3115981.html