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

5 votes169 views1 answer
Alter table add comment oracle
SQL
19 votes185 views6 answers
Mysql if null
SQL
1 vote170 views3 answers
Sql select only time from datetime
SQL
0 vote188 views1 answer
Duplix print in Smartforms
SQL
1 vote273 views1 answer
SQL server query column yes or no
SQL
5 votes210 views2 answers
Functions
SQL
0 vote208 views1 answer
Update sql sintax
SQL
0 vote162 views1 answer
Distinct data types in a table sql query
SQL
3 votes212 views1 answer
Sql online test questions and answers
SQL
0 vote183 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL