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

2 votes329 views1 answer
Oracle trace session
SQL
1 vote367 views1 answer
Insert many to many sql
SQL
0 vote387 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
3 votes345 views2 answers
Oracle apex charging debug
SQL
0 vote342 views1 answer
Oracle archivelog usage
SQL
1 vote340 views2 answers
Mysql select tables with name like
SQL
1 vote355 views1 answer
Write a query to create an empty table from an existing table?
SQL
0 vote336 views3 answers
Joins and views sql
SQL
0 vote327 views1 answer
Print orcale
SQL
2 votes423 views2 answers
Python escape string for sql
SQL