MySQL snippets

Get column names to paste into SELECT query

select group_concat(column_name separator ', ')
from information_schema.columns
where table_schema='<SCHEMA>' and table_name='<TABLE>';