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

2 votes135 views5 answers
Eloquest how to select one specific column in database
SQL
0 vote114 views1 answer
Drop all tables in azure sql database
SQL
0 vote141 views1 answer
For row in sql database python loop
SQL
0 vote133 views1 answer
Mysql add root password
SQL
3 votes140 views1 answer
Select table column in sql
SQL
2 votes112 views1 answer
How to delete columns in sql
SQL
1 vote127 views1 answer
DATE_SUB postgres
SQL
0 vote151 views1 answer
Provera dupliranih konatakata
SQL
1 vote154 views1 answer
Oracle schema size
SQL
0 vote143 views2 answers
Mysql insert into multiple tables
SQL