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

7 votes265 views2 answers
N highest salary in sql
SQL
0 vote258 views1 answer
Html css mobile menu arrow dropdown
SQL
7 votes322 views2 answers
Sql remove duplicates based on column
SQL
0 vote277 views1 answer
Soql user profile
SQL
0 vote279 views1 answer
Sql server roles and users
SQL
4 votes279 views3 answers
Mysql update with join
SQL
0 vote278 views1 answer
Sql show all users
SQL
4 votes277 views1 answer
Sql delete where in select
SQL
6 votes288 views3 answers
Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mydb.term.year' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote253 views1 answer
Sql random decimal
SQL