SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Save MySQL query results into a text or CSV file
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

kt
Yak Posting Veteran

75 Posts

Posted - 04/19/2013 :  15:44:29  Show Profile  Reply with Quote
I found this topic from this link:
http://www.tech-recipes.com/rx/1475/save-mysql-query-results-into-a-text-or-csv-file/

I am try to create the text file from my table but it didn't work with this error: "Incorrect syntax near the keyword 'INTO'.
Does any know? What should i do? - thx

SELECT sale, del
FROM order
INTO OUTFILE 'C:/tmp/orders.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'

robvolk
Most Valuable Yak

USA
15658 Posts

Posted - 04/19/2013 :  16:00:49  Show Profile  Visit robvolk's Homepage  Reply with Quote
SQLTeam is a Microsoft SQL Server website, you're better off asking in a MySQL forum. There's one here: http://dbforums.com/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000