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 vote115 views1 answer
Jooq replace
SQL
1 vote119 views1 answer
Sql run multiple updates in one query
SQL
0 vote115 views1 answer
Postgres jsonb array push new element
SQL
0 vote116 views1 answer
Create table sql generator
SQL
0 vote125 views1 answer
Interview experience as a call?
SQL
0 vote128 views1 answer
Select distinct after join
SQL
0 vote118 views1 answer
Write sql query to show the details start from digit
SQL
9 votes118 views4 answers
How to alter table column name in mysql
SQL
7 votes118 views2 answers
Mysql get year from date
SQL
7 votes109 views3 answers
Add primary key to database sql
SQL