Tips and scripts relating to database administration. Mainly SQL Server but some MySQL and every now and again something different. Posts are brief and to the point.It's as much a place to make notes for my own use as anything else.
Wednesday, 15 October 2008
MySql Outfile
SELECT Field1, field2, … INTO OUTFILE '/tmp/filename.txt' FIELDS TERMINATED BY '#' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM Table
No comments:
Post a Comment