Icerock's Blog Code snippets, useful tips, experiences and a bit of help :o)

SELECT … UNION … INTO OUTFILE

Posted by .: Pampa :.

Quick Tip:

Sometimes you need to dump some data directly to a file.
That's easy by issuing a SELECT ... INTO OUTFILE .... FROM ...

But what happens when you need to retrieve data from in some particular way or when you want to add "headers" to the columns you're outputting?
Likely you'll get an error that UNION statement is not allowed to play with INTO OUTFILE.

So this is the way to output data with UNION:

In that way you're making a compound table from the UNION statement. Then, you select * from that table to the outfile.
Remember to ALWAYS give an alias to a derived table :)

Happy Dumping!