Mysql into outfile with headers

SELECT * FROM (
    SELECT 'username','email'
    UNION ALL
    (
        SELECT `username`,`email`,`steam_id` FROM `users` WHERE `userna` LIKE '%@temp%'
    )
) resulting_set
INTO OUTFILE '/results/result.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';

Source: stackoverflow.com

Similar codes

1 vote177 views1 answer
Select if then postgresql
SQL
1 vote184 views1 answer
Rails run native ssql query
SQL
0 vote132 views1 answer
FindAllBy
SQL
0 vote166 views1 answer
Postgresql default value boolean
SQL
8 votes156 views1 answer
Sql remove characters from string right
SQL
1 vote173 views1 answer
PLS-00225 type
SQL
0 vote153 views1 answer
Mysql does collate nopad recognize space
SQL
0 vote174 views1 answer
Power bi find all ids not in other tables
SQL
2 votes161 views1 answer
Convert series number to date in sql
SQL
11 votes182 views2 answers
Oracle saurce code
SQL