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 vote132 views1 answer
Create email address from first and last name in sql
SQL
0 vote134 views1 answer
Update table sql multiple set
SQL
1 vote154 views1 answer
Select inside insert query
SQL
0 vote134 views1 answer
Pl sql disable trigger
SQL
0 vote122 views1 answer
Incorrect datetime value sql table error 1292
SQL
1 vote135 views1 answer
Where not in array sql
SQL
0 vote132 views1 answer
Mysql select all where count more than"
SQL
0 vote106 views1 answer
Oracle sysdba connect as another user
SQL
2 votes139 views1 answer
Sql find not in list
SQL
15 votes138 views6 answers
Psql
SQL