SELECT
    GROUP_CONCAT( COLUMN_NAME SEPARATOR "    " ) 
FROM
    information_schema.COLUMNS 
WHERE
    TABLE_SCHEMA = 'bioshop_bi_uat' 
    AND TABLE_NAME = 'dwd_receivable'

image.png


阆风
34 声望3 粉丝

简单点就好。