— 查表的所有列
    SELECT * FROM information_schema.columns
    WHERE table_name = ‘zc_tb_ht’

    — 查表的所有列 并拼接
    SELECT GROUP_CONCAT( column_name ORDER BY ordinal_position SEPARATOR “,” ) AS title FROM information_schema.columns
    WHERE table_name = ‘zc_tb_ht’ GROUP BY table_name