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 vote205 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
1 vote183 views2 answers
Sql left characters
SQL
0 vote179 views1 answer
Bigquery declare
SQL
1 vote192 views1 answer
Mysql get max value and id
SQL
0 vote248 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
1 vote173 views1 answer
How to test for sql injection
SQL
0 vote193 views1 answer
Mysql replication change database name
SQL
0 vote143 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL
0 vote276 views1 answer
Select milliseconds mysql
SQL
0 vote201 views1 answer
How to check default value of column in sql server
SQL