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

12 votes216 views5 answers
Rename table in mysql
SQL
0 vote208 views1 answer
Sqlite to csv statement
SQL
1 vote194 views1 answer
Autocommit mysql
SQL
2 votes197 views3 answers
Application.properties spring boot mysql
SQL
1 vote182 views2 answers
Into sql
SQL
2 votes205 views2 answers
Checking data type in sql server
SQL
0 vote263 views1 answer
What is metadata in sql
SQL
2 votes210 views1 answer
Drop all database tables oracle sql developer
SQL
1 vote198 views1 answer
Import sql file mysql commadn line
SQL
6 votes212 views2 answers
Mysql check auto increment value
SQL