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

0 vote214 views1 answer
Criteria builder select subset of column
SQL
0 vote159 views1 answer
How to connect sql server using ip address in c#
SQL
0 vote250 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
0 vote211 views1 answer
Get server date mysql
SQL
0 vote229 views1 answer
Insert value in identity
SQL
1 vote189 views1 answer
How to use a trigger to validate input data
SQL
2 votes331 views1 answer
Mysql create user with remote access
SQL
0 vote197 views1 answer
Mysql undo delete
SQL
0 vote208 views1 answer
Get the First and Last Word from a String or Sentence
SQL
2 votes195 views1 answer
Oracle current date without time
SQL