So, every now and then you may want to have a table or some sql query as a csv or excel file to be able to do certain tasks like graphing etc.
\nHere a quick way to get that.<\/p>\n
This will create a csv file called MyFile.csv that contains the results from the query “sql query”<\/p>\n As an example, if I have a query say, ‘select * from books where title like “The%”;’, running against a MySQL\/mariadb with hostname mydb.local and database items, what we will have is.<\/p>\n If you need this as an excel file, just open with MS excel, make a selection and convert to a table then save as an excel file.<\/p>\n","protected":false},"excerpt":{"rendered":" So, every now and then you may want to have a table or some sql query as a csv or excel file to be able to do certain tasks like graphing etc. Here a quick way to get that. mysql -h Host -uUser -pPassword -D Database -e ‘sql query;’ | sed “s\/’\/\\’\/;s\/\\t\/\\”,\\”\/g;s\/^\/\\”\/;s\/$\/\\”\/;s\/\\n\/\/g” >MyFile.csv<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3],"tags":[18],"_links":{"self":[{"href":"https:\/\/techliness.com\/index.php?rest_route=\/wp\/v2\/posts\/78"}],"collection":[{"href":"https:\/\/techliness.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techliness.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techliness.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/techliness.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=78"}],"version-history":[{"count":8,"href":"https:\/\/techliness.com\/index.php?rest_route=\/wp\/v2\/posts\/78\/revisions"}],"predecessor-version":[{"id":86,"href":"https:\/\/techliness.com\/index.php?rest_route=\/wp\/v2\/posts\/78\/revisions\/86"}],"wp:attachment":[{"href":"https:\/\/techliness.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=78"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techliness.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=78"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techliness.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=78"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}mysql -h Host -uUser -pPassword -D Database -e 'sql query;'<\/em> | sed \"s\/'\/\\'\/;s\/\\t\/\\\",\\\"\/g;s\/^\/\\\"\/;s\/$\/\\\"\/;s\/\\n\/\/g\" >MyFile.csv<\/code>
\n<\/p>\nmysql -h mydb.local -uUser -pPassword -D items -e 'select * from books where title like \"The%\";' | sed \"s\/'\/\\'\/;s\/\\t\/\\\",\\\"\/g;s\/^\/\\\"\/;s\/$\/\\\"\/;s\/\\n\/\/g\" >MyBooks.csv<\/code><\/p>\n