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 vote288 views1 answer
Mysql return column names when table is empty
SQL
1 vote285 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
0 vote295 views1 answer
Select * where id = 1,2,3
SQL
0 vote301 views1 answer
Sql cmd no truncate
SQL
0 vote334 views1 answer
Sql basic commands
SQL
0 vote248 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
5 votes277 views1 answer
Oracle asynchronous query
SQL
5 votes285 views1 answer
Postgres integer to serial
SQL
0 vote286 views1 answer
Merge clause with inner join
SQL
0 vote324 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL