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

0 vote273 views1 answer
Replace string in whole database mysql stackoverflow
SQL
7 votes257 views4 answers
How to reset the identity column in sql server
SQL
1 vote275 views3 answers
Getdate function in postgresql
SQL
0 vote270 views1 answer
Mysqldump ignore table
SQL
0 vote271 views1 answer
Narural join
SQL
0 vote276 views1 answer
Mysql shell ERROR: Not connected.
SQL
3 votes278 views2 answers
Sql asc
SQL
1 vote288 views1 answer
Psql human readable
SQL
0 vote259 views1 answer
Raiserror nowait sql server
SQL
0 vote278 views1 answer
SQL SELECT-Klausel
SQL