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 vote357 views1 answer
Mysql streaming example
SQL
0 vote303 views1 answer
Join in update query in mysql
SQL
6 votes317 views2 answers
Psql load dump
SQL
0 vote270 views1 answer
Select all domains of database firbird
SQL
0 vote311 views1 answer
Sql character index
SQL
0 vote293 views1 answer
Mysql function variable
SQL
0 vote317 views1 answer
Less mysql display
SQL
3 votes299 views3 answers
How to set up an auto incrementing id db browser
SQL
0 vote325 views1 answer
Mysql select random rows large table
SQL
0 vote303 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL