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 vote171 views1 answer
Sqlite update from another table
SQL
0 vote158 views1 answer
Oracle list datafiles
SQL
0 vote186 views1 answer
Mysql relationships between tables
SQL
1 vote182 views1 answer
Print year of a date sql
SQL
0 vote155 views1 answer
Mysql events not work
SQL
1 vote311 views3 answers
Sql subquery
SQL
0 vote196 views1 answer
Sql select rows between 1000 and 2000
SQL
13 votes143 views6 answers
Restart postgresql
SQL
0 vote142 views1 answer
Get number of rows in every table mysql
SQL
0 vote176 views1 answer
Oracle sql date winter time
SQL