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

40 votes246 views4 answers
PostgreSQL add column
SQL
-1 vote187 views1 answer
Capitole toulouse
SQL
0 vote158 views1 answer
Create function syntax sql server
SQL
0 vote169 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
0 vote181 views1 answer
Hex string sql becomes int64
SQL
1 vote179 views1 answer
Oracle create_program
SQL
1 vote216 views1 answer
Select last row from SQL Table
SQL
0 vote385 views1 answer
Power bi connect to postgresql
SQL
0 vote174 views1 answer
Oracle select partition
SQL
0 vote164 views2 answers
Functions with parameters SQL
SQL