SQL to dump to CSV format with header

sql-csv

SELECT GROUP_CONCAT(CONCAT("'", COLUMN_NAME, "'"))
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'patient'
    AND TABLE_SCHEMA = 'db2'
order BY ORDINAL_POSITION
    INTO OUTFILE '/Users/leongkui/Downloads/db2-header.csv'
    FIELDS TERMINATED BY ','
    OPTIONALLY ENCLOSED BY '"'
    LINES TERMINATED BY '\n';

SELECT *
FROM patient
    INTO OUTFILE '/Users/leongkui/Downloads/db2.csv'
    FIELDS TERMINATED BY ','
    OPTIONALLY ENCLOSED BY '"'
    LINES TERMINATED BY '\n';