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 vote215 views1 answer
Mysql drop multiple tables at once
SQL
8 votes228 views3 answers
Postgres connection string
SQL
5 votes232 views1 answer
Sqlite alter table add column
SQL
0 vote209 views1 answer
Import all databases mysql
SQL
0 vote203 views1 answer
Get only first row mysql
SQL
0 vote227 views1 answer
Mysql master slave setup with keepalived
SQL
1 vote226 views1 answer
Oracle create_program
SQL
0 vote228 views1 answer
Less than and between in sql query
SQL
0 vote229 views2 answers
Sql count number of rows after group by
SQL
-1 vote244 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL