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 votes232 views1 answer
Enum in SQL Server
SQL
0 vote197 views1 answer
Java spring boot connect to sql server
SQL
0 vote293 views1 answer
What is metadata in sql
SQL
0 vote248 views2 answers
Script all indexes in a database
SQL
2 votes221 views1 answer
Mysql select random id from table
SQL
2 votes222 views1 answer
Mysql list users on ubuntu
SQL
0 vote246 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
31 votes242 views4 answers
How to get duplicate records with multiple field in sql
SQL
3 votes233 views3 answers
Create table in microsoft sql server
SQL
1 vote200 views1 answer
Enable mysql slow query log
SQL