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 vote346 views1 answer
Create index concurrently postgres
SQL
0 vote321 views1 answer
Zsh: command not found: mysql mamp
SQL
0 vote360 views1 answer
How to update sql server version
SQL
0 vote354 views1 answer
Value of sold product using having and group by in sql
SQL
7 votes362 views5 answers
Show details of table postgres
SQL
0 vote321 views1 answer
Postgresql newline character
SQL
0 vote347 views1 answer
Report in database
SQL
1 vote386 views1 answer
Mysql find most common value
SQL
0 vote343 views1 answer
Declare date variable sql
SQL
6 votes346 views4 answers
Remove spaces sql server
SQL