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

1 vote197 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
1 vote205 views1 answer
Delete dublicate rows sql
SQL
14 votes1.2K views1 answer
Sql value of string
SQL
1 vote179 views1 answer
Create sample data postgresql
SQL
15 votes182 views1 answer
Mysql int range
SQL
0 vote187 views1 answer
One table with another
SQL
2 votes202 views1 answer
Oracle sql merge
SQL
3 votes219 views3 answers
Order by postgres
SQL
1 vote205 views1 answer
Get current date in pyspark sql
SQL
8 votes197 views2 answers
Oracle undo usage
SQL