Get columns of one table

11/27/2014 - 2:45 AM

SELECT GROUP_CONCAT(`COLUMN_NAME`) FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA`='database_name_goes_here' AND `TABLE_NAME`='tabla_name'

Cacher is the code snippet organizer for pro developers