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 vote175 views1 answer
Install mysql for fedora 34
SQL
2 votes190 views1 answer
Column names in oracle sql
SQL
0 vote192 views1 answer
Tsql find procedure with name
SQL
0 vote191 views1 answer
Kill slow queries mysql
SQL
0 vote181 views1 answer
Oracle temporary table
SQL
0 vote194 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
0 vote190 views1 answer
SQL server datetime compare
SQL
0 vote194 views1 answer
How to get first 10 records of a table in mysql
SQL
0 vote182 views1 answer
Sql server split string and insert into table select
SQL
5 votes172 views2 answers
Ranking functions in sql
SQL