{"id":39,"date":"2009-10-06T05:42:00","date_gmt":"2009-10-06T05:42:00","guid":{"rendered":"http:\/\/2paisasbyviggy.wordpress.com\/2009\/10\/06\/import-mysql-query-into-csv"},"modified":"2009-10-06T05:42:00","modified_gmt":"2009-10-06T05:42:00","slug":"import-mysql-query-into-csv","status":"publish","type":"post","link":"https:\/\/blog.viggy.in\/?p=39","title":{"rendered":"import mysql query into csv"},"content":{"rendered":"<p>When you want to import the results of a query into a csv, you can use the following mysql query.<\/p>\n<p>SELECT a,b,a+b INTO OUTFILE &#8216;\/tmp\/result.text&#8217;<br \/>FIELDS TERMINATED BY &#8216;,&#8217; OPTIONALLY ENCLOSED BY &#8216;&#8221;&#8216;<br \/>LINES TERMINATED BY &#8216;n&#8217;<br \/>FROM test_table;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When you want to import the results of a query into a csv, you can use the following mysql query. SELECT a,b,a+b INTO OUTFILE &#8216;\/tmp\/result.text&#8217;FIELDS TERMINATED BY &#8216;,&#8217; OPTIONALLY ENCLOSED BY &#8216;&#8221;&#8216;LINES TERMINATED BY &#8216;n&#8217;FROM test_table;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_s2mail":"","footnotes":""},"categories":[1],"tags":[96,164,210,243],"class_list":["post-39","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-csv","tag-import","tag-mysql","tag-query"],"_links":{"self":[{"href":"https:\/\/blog.viggy.in\/index.php?rest_route=\/wp\/v2\/posts\/39","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.viggy.in\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.viggy.in\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.viggy.in\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.viggy.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=39"}],"version-history":[{"count":0,"href":"https:\/\/blog.viggy.in\/index.php?rest_route=\/wp\/v2\/posts\/39\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.viggy.in\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=39"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.viggy.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=39"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.viggy.in\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=39"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}