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

  • Mike

    4 months ago

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

    Bookmarked.
    reply
  • sshah

    3 months ago

    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?
    reply
  • Amit

    2 months ago

    I am facing the same problem. Did you find the answer?
    reply
  • Heini

    1 month ago

    Just like this:

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

    Just type in the drive you want.
    reply
  • Udit Chaudhary

    2 days ago

    This happens only if you have executed the query twice and redirecting it to same location with same name otherwise rest is fine.
    reply
  • Sumesh

    2 months ago

    Is there a similar thing available in oracle?
    reply
  • Leion

    2 months ago

    How can I used a a date value in the output file?
    reply
  • jai

    1 week ago

    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................
    reply

Add New Comment

Returning? Login