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 vote136 views1 answer
Events not working db
SQL
0 vote149 views1 answer
Bitmap join index
SQL
1 vote147 views1 answer
SQL: merging multiple row data in string
SQL
0 vote145 views1 answer
Dapper run sql script with parameters
SQL
0 vote185 views1 answer
Opensuse start MySQL
SQL
-2 votes139 views3 answers
Oracle tablespace usage
SQL
0 vote133 views1 answer
Edit a field mysql terminal
SQL
0 vote142 views1 answer
Sql change date format
SQL
0 vote169 views1 answer
Add new column in sql with foreign key
SQL
4 votes138 views2 answers
How to count items with same name in sql
SQL