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 vote179 views1 answer
Postgres select except
SQL
1 vote194 views1 answer
Sql run multiple updates in one query
SQL
0 vote252 views2 answers
Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.
SQL
0 vote201 views1 answer
Select row from mysql where date more than 30 days
SQL
1 vote217 views1 answer
How not to sort by average rating
SQL
1 vote207 views1 answer
Sql server cast date dd/mm/yyyy
SQL
0 vote245 views1 answer
Select multiple row from primary key sql
SQL
1 vote194 views2 answers
How to drop a unique constraint in sql
SQL
0 vote190 views1 answer
Copy value from one column to another postgres
SQL
5 votes178 views2 answers
Add column postgres with default value
SQL