mysql查询列

SELECT

CONCAT(COLUMN_NAME,"," )

FROM

information_schema.COLUMNS

WHERE

TABLE_SCHEMA = 'recruit'

AND TABLE_NAME = 'job_info';