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

8 votes328 views2 answers
Update sql server from another table
SQL
4 votes293 views1 answer
Mysql not equal
SQL
2 votes287 views1 answer
Node and mysql like
SQL
0 vote290 views1 answer
Varchar format not case sensitive sql
SQL
1 vote337 views1 answer
Find size of all DB's postgres
SQL
0 vote255 views1 answer
Print sum of values sql
SQL
2 votes288 views2 answers
Checking data type in sql server
SQL
4 votes309 views2 answers
Truncate oracle
SQL
0 vote301 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
0 vote288 views1 answer
Difference between varchar and varchar2
SQL