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

7 votes281 views1 answer
Oracle alter sequence restart start with
SQL
0 vote151 views1 answer
Alter session set nls_language french
SQL
0 vote199 views1 answer
How to add timestamp column in mysql
SQL
0 vote180 views1 answer
SQL server select to get sum of hours
SQL
0 vote190 views1 answer
Min:sec datediff mssql
SQL
0 vote197 views1 answer
Mysql, how to query the table comments?
SQL
2 votes227 views6 answers
In operator in sql
SQL
1 vote176 views1 answer
PLS-00225 type
SQL
1 vote195 views1 answer
Mysql list bigger table
SQL
33 votes197 views6 answers
Change column name in mysql
SQL