SELECT column_name
FROM information_schema.columns
WHERE table_schema = 'yourdb'
AND table_name = 'tablename';
Just edit the bold parts above, it's great when coding database applications and saves a bit of time.
mysql, attributesselect, column_name, information_schema, columns, table_schema, yourdb, table_name, tablename, edit, bold, coding, database, applications, saves,