{"id":899,"date":"2003-06-05T06:04:56","date_gmt":"2003-06-05T06:04:56","guid":{"rendered":"http:\/\/dev.jblove.net\/?p=899"},"modified":"2003-06-05T06:04:56","modified_gmt":"2003-06-05T06:04:56","slug":"select-into-outfile","status":"publish","type":"post","link":"https:\/\/jblove.net\/?p=899","title":{"rendered":"select .. into outfile"},"content":{"rendered":"

\ub098\uc911\uc5d0 \uba85\ub839\uc5b4 \ub2e4\uc2dc \uce58\uae30 \uadc0\ucc2e\uc544\uc11c… ^^;<\/p>\n

SELECT subject,content into outfile ‘\/home\/aa\/aa.csv’ fields terminated by ‘,’ enclosed by ‘”‘ escaped by ‘\\’ lines terminated by ‘
\n‘ FROM `ch_d_1` WHERE content like ‘%\uae09\uc5ec%’ or content like ‘%\uc218\ub2f9%’;<\/p>\n","protected":false},"excerpt":{"rendered":"

\ub098\uc911\uc5d0 \uba85\ub839\uc5b4 \ub2e4\uc2dc \uce58\uae30 \uadc0\ucc2e\uc544\uc11c… ^^; SELECT subject,content into outfile ‘\/home\/aa\/aa.csv’ fields terminated by ‘,’ enclosed by ‘”‘ escaped by ‘\\’ lines terminated by ‘ ‘ FROM `ch_d_1` WHERE content like ‘%\uae09\uc5ec%’ or content like ‘%\uc218\ub2f9%’;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[51],"tags":[],"class_list":["post-899","post","type-post","status-publish","format-standard","hentry","category-papa-php"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts\/899","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=899"}],"version-history":[{"count":0,"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts\/899\/revisions"}],"wp:attachment":[{"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=899"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=899"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=899"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}