SyntaxFix
Write A Post
Hire A Developer
Questions
This will alow you to have ordered columns and/or a limit
SELECT 'ColName1', 'ColName2', 'ColName3' UNION ALL SELECT * from (SELECT ColName1, ColName2, ColName3 FROM YourTable order by ColName1 limit 3) a INTO OUTFILE '/path/outfile';