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 vote320 views1 answer
Oracle last character of string
SQL
7 votes340 views1 answer
Oracle pagination query offset
SQL
0 vote426 views1 answer
How to show current database in mysql
SQL
1 vote318 views1 answer
Oracle rolling back transactions
SQL
2 votes306 views2 answers
Mysql all columns
SQL
-1 vote348 views2 answers
Installing mysql on centos 7
SQL
0 vote297 views1 answer
Postgres get running query
SQL
2 votes357 views1 answer
Oracle block
SQL
0 vote324 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL
3 votes319 views1 answer
V$session not found in oracle
SQL