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 vote204 views2 answers
Sql drop multiple columns if exists
SQL
1 vote187 views1 answer
Sql avg group by
SQL
0 vote263 views1 answer
Start stop mysql linux
SQL
0 vote216 views2 answers
Mysql calcular idade
SQL
4 votes209 views3 answers
Check if two date ranges overlap sql server
SQL
10 votes256 views4 answers
Mysql one week ago
SQL
1 vote225 views1 answer
Mysql view current queries
SQL
5 votes225 views1 answer
Oracle get ddl
SQL
1 vote224 views1 answer
Psql human readable
SQL
-1 vote201 views1 answer
How to create foreign key in sql server management studio
SQL