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 vote231 views1 answer
Mysql cli output to a file
SQL
0 vote225 views1 answer
Add multiple field in table sql
SQL
6 votes212 views2 answers
Mysql set primary key
SQL
9 votes235 views3 answers
Find all tables with column name
SQL
1 vote207 views1 answer
Select 2 rows in sql
SQL
0 vote184 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
1 vote169 views2 answers
Get date from datetime postgresql
SQL
18 votes210 views2 answers
Sql inner join
SQL
22 votes205 views3 answers
Join three tables sql
SQL
0 vote231 views1 answer
Normalization in database
SQL