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 vote360 views1 answer
Tsql get beginning of year
SQL
1 vote367 views1 answer
Select users with same username
SQL
0 vote370 views1 answer
Ms sql filter all sympbol
SQL
1 vote387 views1 answer
Mysql select row max date
SQL
6 votes342 views4 answers
Sqlite drop table
SQL
0 vote350 views2 answers
How to know the character set of an oracle databes
SQL
1 vote341 views1 answer
Oracle rolling back transactions
SQL
0 vote343 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
8 votes307 views8 answers
Second highest salary in mysql
SQL
20 votes338 views2 answers
Counting in sql
SQL