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 vote145 views1 answer
Procedures sql insert mysql
SQL
9 votes181 views1 answer
No sql
SQL
-1 vote138 views1 answer
How to open blade file from blade in laravel
SQL
0 vote146 views1 answer
Rows, INSERT INTO, Returning
SQL
0 vote184 views1 answer
Capabilities of sql select statements
SQL
1 vote96 views1 answer
Mysql collation
SQL
4 votes171 views4 answers
Remove duplicate old value in mysql
SQL
0 vote144 views1 answer
Drop all triggers oracle
SQL
4 votes137 views4 answers
Date less than in sql
SQL
0 vote162 views1 answer
To Create directory
SQL