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

1 vote197 views3 answers
Alter schema sql server
SQL
0 vote207 views1 answer
Postgres sequence name
SQL
10 votes187 views5 answers
Between keyword in sql
SQL
1 vote197 views1 answer
Select count distinct multiple columns sql server
SQL
1 vote202 views2 answers
Mysql allow remote connections
SQL
37 votes202 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
8 votes189 views3 answers
Alter user root mysql
SQL
0 vote198 views1 answer
How to to get current date in sql
SQL
1 vote193 views1 answer
Get url of cpanel database hostname
SQL
0 vote217 views1 answer
SQL joins in python
SQL