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 vote140 views1 answer
Create relationship with betwen two tables in postgersql
SQL
0 vote130 views1 answer
Mssql current date
SQL
16 votes143 views3 answers
Update table from another table
SQL
3 votes86 views1 answer
How to get list of synonyms in oracle
SQL
0 vote197 views1 answer
How to get number of months between 2 dates sql server
SQL
0 vote166 views1 answer
Sql anywhere create procedure
SQL
0 vote141 views1 answer
Python mysql show databases
SQL
0 vote141 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
2 votes131 views2 answers
Mysql on duplicate key ignore
SQL
0 vote144 views1 answer
Oracle concat datetime
SQL