{"id":1169,"date":"2020-12-28T00:25:29","date_gmt":"2020-12-27T15:25:29","guid":{"rendered":"http:\/\/leenux.kr\/?p=1169"},"modified":"2021-12-28T12:36:44","modified_gmt":"2021-12-28T03:36:44","slug":"mariadb-%ec%9e%90%eb%8f%99-%ec%a6%9d%ea%b0%80","status":"publish","type":"post","link":"https:\/\/leenux.kr\/?p=1169","title":{"rendered":"[MariaDB] \uc790\ub3d9 \uc99d\uac00"},"content":{"rendered":"\n<p class=\"has-text-color has-very-dark-gray-color\"><strong>\uc774\ubbf8 \ub9cc\ub4e4\uc5b4\uc9c4 \uceec\ub7fc\uc5d0 AUTO_INCREMENT \uc18d\uc131 \ubcc0\uacbd\ud558\uae30<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER TABLE [\ud14c\uc774\ube14\uba85] MODIFY [\uceec\ub7fc\uba85] [\ub370\uc774\ud130\ud0c0\uc785:int] AUTO_INCREMENT;<\/code><\/pre>\n\n\n\n<p class=\"has-text-color has-very-dark-gray-color\"><strong>AUTO_INCREMENT  \uc9c0\uc815 \uac12 \ucd08\uae30\ud654<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER TABLE [\ud14c\uc774\ube14\uba85] AUTO_INCREMENT=[\uc2dc\uc791\ud560\ub824\ub294 \uc21c\uc11c]<\/code><\/pre>\n\n\n\n<p class=\"has-text-color has-very-dark-gray-color\"><strong>AUTO_INCREMENT \uc7ac\uc815\ub82c<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SET @COUNT = 0;\nUPDATE [\ud14c\uc774\ube14\uba85] SET [\uceec\ub7fc\uba85] = @COUNT:=@COUNT+1;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>MariaDB\uc5d0\uc11c AUTO_INCREMENT \uc790\ub3d9 \uc99d\uac00 \uc801\uc6a9 \ubc29\ubc95<\/p>\n","protected":false},"author":1,"featured_media":1069,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[39,27],"tags":[],"_links":{"self":[{"href":"https:\/\/leenux.kr\/index.php?rest_route=\/wp\/v2\/posts\/1169"}],"collection":[{"href":"https:\/\/leenux.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/leenux.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/leenux.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/leenux.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1169"}],"version-history":[{"count":1,"href":"https:\/\/leenux.kr\/index.php?rest_route=\/wp\/v2\/posts\/1169\/revisions"}],"predecessor-version":[{"id":1170,"href":"https:\/\/leenux.kr\/index.php?rest_route=\/wp\/v2\/posts\/1169\/revisions\/1170"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/leenux.kr\/index.php?rest_route=\/wp\/v2\/media\/1069"}],"wp:attachment":[{"href":"https:\/\/leenux.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1169"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/leenux.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1169"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/leenux.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1169"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}