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 vote268 views1 answer
Create a plsql object
SQL
12 votes260 views2 answers
Delete all entries postgres
SQL
1 vote264 views1 answer
Postgres power
SQL
8 votes272 views1 answer
My sql version
SQL
0 vote418 views1 answer
Sql change a colum to unique
SQL
0 vote289 views1 answer
Joomla execute raw sql
SQL
0 vote282 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
14 votes304 views6 answers
Finding duplicate rows mysql
SQL
0 vote253 views1 answer
Partitioning in oracle-base
SQL
5 votes263 views1 answer
Sort order on two columns sql
SQL