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 vote304 views1 answer
Sort by last two number sql
SQL
12 votes302 views1 answer
How to change the value of a table in sql
SQL
0 vote304 views1 answer
Uuid sqlalcomany
SQL
0 vote288 views1 answer
Sqlite3 not commit
SQL
11 votes303 views2 answers
Import sql file laravel cmd
SQL
8 votes298 views1 answer
Sql remove characters from string right
SQL
3 votes326 views1 answer
Oracle failed login attempts
SQL
0 vote315 views1 answer
Luu ckeditor vao mysql
SQL
0 vote298 views1 answer
Go install mysql
SQL
0 vote320 views1 answer
Sqlite commands
SQL