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 vote164 views1 answer
Grant privileges mysql to database 1064
SQL
0 vote102 views1 answer
Mssql view column data type
SQL
0 vote146 views1 answer
Optimize sql query
SQL
0 vote142 views1 answer
Postgres float to int
SQL
0 vote197 views1 answer
Sqlalchemy query return only n results
SQL
11 votes135 views2 answers
Insert date sql
SQL
1 vote141 views1 answer
Drop df constraint sql server
SQL
1 vote223 views1 answer
Python clean sql string
SQL
0 vote157 views1 answer
Create relationship with betwen two tables in postgersql
SQL
13 votes137 views6 answers
Mysql update from select
SQL