{"id":373,"date":"2021-10-25T11:11:03","date_gmt":"2021-10-25T02:11:03","guid":{"rendered":"https:\/\/blog.mydepot.kr\/?p=373"},"modified":"2021-10-25T11:11:03","modified_gmt":"2021-10-25T02:11:03","slug":"mysql-%ed%94%84%eb%a1%9c%ec%8b%9c%ec%a0%80%eb%a1%9c-%eb%b0%98%eb%b3%b5-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%82%bd%ec%9e%85","status":"publish","type":"post","link":"https:\/\/blog.mydepot.kr\/?p=373","title":{"rendered":"[mySql] \ud504\ub85c\uc2dc\uc800\ub85c \ubc18\ubcf5 \ub370\uc774\ud130 \uc0bd\uc785"},"content":{"rendered":"<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nBEGIN\nDECLARE i INT DEFAULT 1; \nWHILE (i &lt;= 118) DO\n    INSERT INTO tbl_receiver (rec,recName,recType,recIp) VALUES (i,CONCAT(i, &quot;\ubc88\uc218\uc2e0\uae30&quot;), 6, CONCAT(&quot;0&quot;, 1012340000 + i));\n    SET i = i+1;\nEND WHILE;\nEND\n<\/pre><\/div>\n\n\n<p>\ud504\ub85c\uc2dc\uc800(\ub8e8\ud2f4) \uc0dd\uc131 \ud6c4 \ud504\ub85c\uc2dc\uc800 \uc2e4\ud589.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ud504\ub85c\uc2dc\uc800(\ub8e8\ud2f4) \uc0dd\uc131 \ud6c4 \ud504\ub85c\uc2dc\uc800 \uc2e4\ud589.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"categories":[9],"tags":[162,163,52],"class_list":["post-373","post","type-post","status-publish","format-standard","hentry","category-sql","tag-mysql","tag-163","tag-52"],"modified_by":"\ucc38\ube5b\ubc14\ub2e4","_links":{"self":[{"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/posts\/373","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=373"}],"version-history":[{"count":1,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/posts\/373\/revisions"}],"predecessor-version":[{"id":374,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/posts\/373\/revisions\/374"}],"wp:attachment":[{"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=373"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=373"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=373"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}