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 vote152 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
7 votes174 views1 answer
Sql pagination oracle
SQL
0 vote156 views1 answer
Sqlite referential integrity
SQL
0 vote160 views1 answer
Sqlite3 get data from table c
SQL
0 vote143 views1 answer
Postgres create database if not exists
SQL
0 vote155 views1 answer
Kill thread
SQL
1 vote159 views1 answer
Convert epoch to date in sql server
SQL
10 votes164 views2 answers
Mysql remove only_full_group_by permanently
SQL
0 vote156 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
0 vote166 views1 answer
Sql update subtract value
SQL