SELECT column_name, data_type
--SELECT CONCAT(column_name, ',')
FROM   information_schema.columns
WHERE  table_name = 'foo'
ORDER  BY ordinal_position;