-
Website
http://www.tech-recipes.com/ -
Original page
http://www.tech-recipes.com/rx/1475/save-mysql-query-results-into-a-text-or-csv-file/ -
Subscribe
All Comments -
Community
-
Top Commenters
-
davak
83 comments · 1 points
-
danishbacker
9 comments · 1 points
-
flexinfo
11 comments · 1 points
-
bej
4 comments · 1 points
-
dimithri
5 comments · 1 points
-
-
Popular Threads
-
Windows 7: How to Prevent the Mouse from Waking your PC
9 hours ago · 1 comment
-
Outlook 2010: Turn Off Attachment Preview
1 week ago · 1 comment
-
Gmail: How to Send SMS Messages Without Using Email
2 weeks ago · 2 comments
-
Windows 7 – Prevent Live Messenger from Opening at Start Up
1 week ago · 1 comment
-
Symfony: Drop Down List Box Without Submit Button
3 weeks ago · 1 comment
-
Windows 7: How to Prevent the Mouse from Waking your PC
Bookmarked.
SELECT order_id,product_name,qty
FROM orders
INTO OUTFILE 'c:/tmp/orders.csv'
Just type in the drive you want.
Anyone know how to get this file created on the local host?
am using version 5.0...
could some one plz help me out................
Bookmarked."
it was those people who memorized syntax or function than understanding what a language can do or cant do was noob.
thanks a lot!
Many thanks again.
Reg Bailey.
Also discovered that including the 'optionally' keyword, eg:
... optionally enclosed by '"' ...
that MySQL will decide which fields (eg. text, char etc) need enclosing in double quotes and which fields (eg. int, float etc) do not in order to comply with strict CSV format. Depending on your table make-up & size, this too is a great time saver. Mant thanks again for pointing me (and many others) in the right direction.
Reg.