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 vote330 views1 answer
Select in select sql
SQL
0 vote349 views1 answer
Oracle sql alter view add column
SQL
0 vote410 views1 answer
Sqlite display headers on columns
SQL
6 votes328 views1 answer
Sql insert values into table
SQL
0 vote326 views2 answers
How to create a table from another table in sql derby
SQL
0 vote321 views1 answer
Sql column as header
SQL
0 vote330 views3 answers
Postgresql grant alter table to user
SQL
0 vote309 views2 answers
Php convert dbf to mysql
SQL
5 votes341 views1 answer
How to get all table names in sql query
SQL
2 votes352 views3 answers
Mysql pass command from command line
SQL