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 vote134 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
5 votes110 views2 answers
Copy data from one database to another
SQL
0 vote105 views1 answer
Sql change date format
SQL
3 votes147 views2 answers
Check data in table mysql
SQL
1 vote140 views1 answer
Concat first name and last name in mysql
SQL
0 vote114 views1 answer
Group_concat only returns one row
SQL
1 vote120 views2 answers
Mysql: command not found
SQL
0 vote119 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
10 votes110 views1 answer
All_dependencies
SQL
0 vote120 views1 answer
RowDataPacket
SQL