Preview:
SELECT column_name, data_type
--SELECT CONCAT(column_name, ',')
FROM   information_schema.columns
WHERE  table_name = 'foo'
ORDER  BY ordinal_position;
downloadDownload PNG downloadDownload JPEG downloadDownload SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter