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 vote259 views2 answers
Create sequence if not exists postgres
SQL
0 vote251 views1 answer
Add column to table with default value plsql
SQL
0 vote274 views1 answer
Hex string sql becomes int64
SQL
0 vote296 views1 answer
Oracle chain step succeeded
SQL
0 vote299 views1 answer
Sql basic commands
SQL
1 vote228 views1 answer
Insert into sql
SQL
0 vote296 views1 answer
Sql pivot without aggregate
SQL
1 vote248 views1 answer
Stop mysql server mac
SQL
3 votes283 views2 answers
See mysql users ubuntu
SQL
25 votes281 views6 answers
Import database mysql command line
SQL