Friday, June 15, 2012

Save MySQL query results from console

I assume you have logged into your MySQL console. You can save your query result into a file like below:

Text File 

SELECT * FROM your_table .
INTO OUTFILE '/tmp/file.txt'

CSV File

SELECT * FROM your_table 
       INTO OUTFILE '/tmp/file.csv'
       ENCLOSED BY '"'

Reference :


  1. Hi, I desire to subscribe for this web site to obtain most up-to-date updates, so where can i do it please help.
    web design firm in tampa

    1. You may use this blog feed and get the recent updates.

  2. Are you planning to spend your weekend or vacation in camping? Our store contains all necessary camping equipment. The quality of our products and our prices will delight you. Camping Supplies

  3. Thanks for this valuable post Pro Website Development and Operations gives us the experience we need to create and operate a large scale production website. Each website has its own unique set of problems regarding its design problems that can get worse when agile methodologies are adopted for rapid results.

  4. Great and impressive article.!! Got to learn and know more about web designing.

    school prospectus

  5. Good to learn something new from this blog. Thanks for sharing such worthy article. By frozen games online

  6. Much informative things are in this blog. Thanks for giving us such valuable blog.

    electrical contractors in chennai

  7. Each custom website design we provide will have several things included (unless you'd really rather we not, of course).
    Web guy

  8. We are a professional Website Designing Company in Krachi, Pakistan, providing affordable and personalized Web Designing for Building Business Websites.

  9. Thanks for sharing such worthy article.We are a professional Website Designing Company in Minnesota.Pakistan

  10. A really good post man, very thankful and hopeful that you will write many more posts like this one.

    appvn apk
    tutuapp apk ios

  11. What our market cares about is their problem, not the looks of our web site. They are not going to share our web site with others because it looks cool, but they will share when our business web site helps them and educates them about our industry and how to make the best choice for their needs.vizitinių kortelių maketavimas

  12. Thanks for provide great informatic and looking beautiful blog, really nice required information & the things i never imagined and i would request, wright more blog and blog post like that for us. Thanks you once agian Marriage certificate , Marriage certificate delhi, Marriage certificate in delhi, Marriage certificate online, online Marriage certificate