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

3 votes398 views2 answers
Oracle sql first day of month
SQL
16 votes362 views3 answers
Jwt secret key generator laravel
SQL
0 vote358 views1 answer
Create table sql generator
SQL
0 vote400 views1 answer
Dynamic where clause in sql server stored procedure
SQL
0 vote315 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL
10 votes482 views4 answers
Sql server pagination
SQL
0 vote350 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
0 vote374 views1 answer
Mysql match in serialized data
SQL
0 vote330 views1 answer
How to drop columns with constraint from a table in sql script
SQL
0 vote356 views1 answer
How to close external sql connection in laravel
SQL