DISQUS

DISQUS Hello! Tech-Recipes is using DISQUS, a powerful comment system, to manage its comments. Learn more.

Community Page

Tech-Recipes

Cookbook of Tech Tutorials
Jump to original thread »
Author

Save MySQL query results into a text or CSV file | MySQL | Tech-Recipes

Started by qdideas · 9 months ago

No excerpt available. Jump to website »

8 comments

  • Thanks for this, a MySQL noob like myself always forgets the exact syntax!

    Bookmarked.
  • Thanks for the helpful post but my problem is that when i execute the query and go to the location where i saved the file, i can't find any file there. However if i again try the same command it says "File already exists" but actually there is not. Wha'ts wrong?
  • I am facing the same problem. Did you find the answer?
  • Just like this:

    SELECT order_id,product_name,qty
    FROM orders
    INTO OUTFILE 'c:/tmp/orders.csv'

    Just type in the drive you want.
  • This happens only if you have executed the query twice and redirecting it to same location with same name otherwise rest is fine.
  • Is there a similar thing available in oracle?
  • How can I used a a date value in the output file?
  • I dont know y the new line operator is not at all working in my MySql...
    am using version 5.0...


    could some one plz help me out................

Add New Comment

Returning? Login