{"id":647,"date":"2015-04-05T22:28:44","date_gmt":"2015-04-06T07:28:44","guid":{"rendered":"http:\/\/blog.box.kr\/?p=647"},"modified":"2015-04-05T22:28:44","modified_gmt":"2015-04-06T07:28:44","slug":"mysql%ec%97%90%ec%84%9c-auto-increment-column%ec%9d%98-%ec%9e%85%eb%a0%a5-%ea%b0%92-%ea%b0%80%ec%a0%b8%ec%98%a4%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/blog.box.kr\/?p=647","title":{"rendered":"MYSQL\uc5d0\uc11c AUTO INCREMENT column\uc758 \uc785\ub825 \uac12 \uac00\uc838\uc624\uae30.."},"content":{"rendered":"<p>INSERT \uc2e4\ud589 \ud6c4\uc5d0\u00a0SELECT<span style=\"color: #ff0000;\"> LAST_INSERT_ID() ;<\/span><\/p>\n<p>\ud558\uba74 \ub41c\ub2e4. \u00a0 \ud574\ub2f9 Session\uc5d0\uc11c\ub9cc \uc694\ud6a8 \ud558\uae30 \ub54c\ubb38\uc5d0 \ub3d9\uc77c \ud14c\uc774\ube14\uc5d0 \uc5ec\ub7ec \uc785\ub825\uc774 \uc788\ub354\ub77c\ub3c4<\/p>\n<p>session\uc774 \uc720\uc9c0\ub418\ub294 \ud55c\uc740 \uc720\uc9c0 \ub41c\ub2e4.<\/p>\n<p>\uadf8\ub9ac\uace0 \ub370\uc774\ud130 \uc0ad\uc81c\ud6c4 \ub610\ub294 \ud14c\uc774\ube14 \uc0dd\uc131 \ud6c4 \ud2b9\uc815 \ubc88\ud638 \uc774\ud6c4\ub85c \u00a0\uc77c\ub828 \ubc88\ud638\uac00 \uc0dd\uc131\ub418\uac8c \ud560\ub824\uba74<\/p>\n<p><strong>ALTER TABLE<\/strong>\u00a0table_name\u00a0<strong>AUTO_INCREMENT = 100;<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>\uc774\ub807\uac8c \ud558\uba74 \ub41c\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>INSERT \uc2e4\ud589 \ud6c4\uc5d0\u00a0SELECT LAST_INSERT_ID() ; \ud558\uba74 \ub41c\ub2e4. \u00a0 \ud574\ub2f9 Session\uc5d0\uc11c\ub9cc \uc694\ud6a8 \ud558\uae30 \ub54c\ubb38\uc5d0 \ub3d9\uc77c \ud14c\uc774\ube14\uc5d0 \uc5ec\ub7ec \uc785\ub825\uc774 \uc788\ub354\ub77c\ub3c4 session\uc774 \uc720\uc9c0\ub418\ub294 \ud55c\uc740 \uc720\uc9c0 \ub41c\ub2e4. \uadf8\ub9ac\uace0 \ub370\uc774\ud130 \uc0ad\uc81c\ud6c4 \ub610\ub294 \ud14c\uc774\ube14 \uc0dd\uc131 \ud6c4 \ud2b9\uc815 \ubc88\ud638 \uc774\ud6c4\ub85c \u00a0\uc77c\ub828 \ubc88\ud638\uac00 \uc0dd\uc131\ub418\uac8c \ud560\ub824\uba74 ALTER TABLE\u00a0table_name\u00a0AUTO_INCREMENT = 100; &nbsp; \uc774\ub807\uac8c \ud558\uba74 \ub41c\ub2e4. &nbsp;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"ngg_post_thumbnail":0,"spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[5],"tags":[],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5q9Zn-ar","jetpack-related-posts":[{"id":408,"url":"https:\/\/blog.box.kr\/?p=408","url_meta":{"origin":647,"position":0},"title":"jboss \ucee8\ud14c\uc774\ub108 \ucd94\uac00 \ud558\uae30..","date":"2014-11-04","format":false,"excerpt":"\ucee8\ud14c\uc774\ub108 \ucd94\uac00 \ud558\uace0 ajp\uc5f0\uacb0\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 port\ub97c \ubcc0\uacbd \ud558\uae30 \uc704\ud574\uc11c\ub294 \/usr\/local\/jboss-6.1.0.Final\/server\/\ucee8\ud14c\uc774\ub108\uba85\/conf\/bindingservice.beans\/META-INF\/bindings-jboss-beans.xml \uc5d0\uc11c Ports03Bindings \uc5d0 \ud574\ub2f9 \ucee8\ud14c\uc774\ub108\uc758 port offset\uc744 \uc218\uc815 \ud558\uba74 \ub41c\ub2e4. \uc5ec\uae30\uc5d0 100 \uc774\uba74 8109 200\uc774\uba74 8209 300\uc774\uba74 8309 400\uc774\uba74 8409 500\uc774\uba74 8509 \uc774\ub7f0\uc2dd\uc73c\ub85c \ucc98\ub9ac \ub41c\ub2e4.. \u00a0 \uc989.. \ucee8\ud14c\uc774\ub108 \uc218 *100 \ud558\uba74 \ub41c\ub2e4.. \u00a0 \u00a0","rel":"","context":"In &quot;jboss&amp;tomcat&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":649,"url":"https:\/\/blog.box.kr\/?p=649","url_meta":{"origin":647,"position":1},"title":"[\ud38c]Tomcat7 tomcat-jdbc \uc124\uc815 &#8211; Broken pipe \uc5d0\ub7ec \ud68c\ud53c","date":"2015-04-05","format":false,"excerpt":"tomcat-jdbc\ub85c MySQL\uc5d0 \uc5f0\uacb0\ud55c \uacbd\uc6b0 \"java.net.SocketException: Broken pipe\" \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud558\ub294 \uacbd\uc6b0\ub97c \uac00\ub054 \ubcfc \uc218 \uc788\ub2e4. \ub300\ubd80\ubd84\uc758 \uacbd\uc6b0 connection idle time\uc774 MySQL\uc5d0 \uc124\uc815\ub41c wait_timeout\uc744 \uc9c0\ub098\uc11c DB\uc5d0\uc11c \uc5f0\uacb0\uc744 \ub04a\uc740 \uac83\uc774\ub2e4. \uc774\ub97c \ubc29\uc9c0\ud558\ub824\uba74 connection\uc774 \uc77c\uc815 \uae30\uac04\ub3d9\uc548 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\uc73c\uba74 close\ub418\ub3c4\ub85d \uc124\uc815\ud558\uac70\ub098 connection \ub300\uc5ec\uc2dc\uc5d0 connection\uc744 \uccb4\ud06c\ud558\ub3c4\ub85d \ud558\uba74 \ub41c\ub2e4. \uc124\uc815 1 - \uc77c\uc815 \uae30\uac04\ub3d9\uc548 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\uc73c\uba74 connection\uc744\u2026","rel":"","context":"In &quot;\uae30\uc220\uc790\ub8cc&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1239,"url":"https:\/\/blog.box.kr\/?p=1239","url_meta":{"origin":647,"position":2},"title":"Flutter \uc0ac\uc6a9 \uc815\ub9ac","date":"2021-05-14","format":false,"excerpt":"OSX, Windows, Linux, Web\uc5d0\uc11c \uc0ac\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294 \uac01 \uae30\ub2a5\uc744 \ucf1c\uc918\uc57c\ud568. Flutter\ub85c \ub370\uc2a4\ud06c\ud1b1 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uac1c\ubc1c \uc2dc\uc791\ud558\uae30 \uc77c\ud68c\uc131 \uad6c\uc131 \ubcc0\uacbd\uc73c\ub85c \ub370\uc2a4\ud06c\ud1b1 \uc9c0\uc6d0\uc744 \uad6c\uc131\ud574\uc57c\ud569\ub2c8\ub2e4.$ flutter config --enable-windows-desktop # for the Windows runner$ flutter config --enable-macos-desktop \u00a0 # for the macOS runner$ flutter config --enable-linux-desktop \u00a0 # for the Linux runner \ub370\uc2a4\ud06c\ud1b1 \uc6a9 Flutter\uac00 \ud65c\uc131\ud654\ub418\uc5c8\ub294\uc9c0\u2026","rel":"","context":"In &quot;flutter&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":701,"url":"https:\/\/blog.box.kr\/?p=701","url_meta":{"origin":647,"position":3},"title":"TOMCAT Virtual Host\ub9cc\ub4e4\uae30","date":"2015-04-15","format":false,"excerpt":"1.\u00a0${catalina.home}\/conf\/server.xml \ud654\uc77c\uc744 \uc5f4\uc5b4\uc11c \uc544\ub798\uc640 \uac19\uc774 \ubcc0\uacbd <Engine name=\"Catalina\"defaultHost=\"localhost\"debug=\"0\"> To <Engine name=\"Catalina\"defaultHost=\"www.example.com\"debug=\"0\"> ** \uc5ec\uae30\uc11c \uc9c0\uc815\ud55c defaultHost\ub294 \uc9c0\uc815\ub418\uc9c0 \uc54a\uc740 \uc0c1\ud0dc\ub85c \uc811\uc18d ( ie. IP\ub85c \uc811\uc18d \ub4f1 )\uc77c\ub54c \uae30\ubcf8\uc73c\ub85c \ubcf4\uc77c \uc0ac\uc774\ud2b8 2. \uc0ac\uc6a9\ud560 \uac00\uc0c1 \ud638\uc2a4\ud2b8 \uc815\ubcf4\ub97c \ucd94\uac00 <Host name=\"localhost\"debug=\"0\"appBase=\"webapps\" \u00a0unpackWARs=\"true\"autoDeploy=\"true\" \u00a0xmlValidation=\"false\"xmlNamespaceAware=\"false\"> To \u00a0 \u00a0<Host name=\"www.example.com\"debug=\"0\"appBase=\"public\" \u00a0 \u00a0 \u00a0 \u00a0unpackWARs=\"true\"autoDeploy=\"true\" \u00a0 \u00a0 \u00a0 \u00a0xmlValidation=\"false\"xmlNamespaceAware=\"false\">\u2026","rel":"","context":"In &quot;\uae30\uc220\uc790\ub8cc&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":669,"url":"https:\/\/blog.box.kr\/?p=669","url_meta":{"origin":647,"position":4},"title":"CentOS 7 \/ RHEL 7  service \uba85\ub839\uc5b4\uac00 \ubc14\ub00c\uc5c8\ub2e4..","date":"2015-04-13","format":false,"excerpt":"CentOS 7 \/ RHEL 7 \uac00 \ub418\uba74\uc11c \uae30\uc874\uc5d0 \uc0ac\uc6a9\ud558\ub358 service \uba85\ub839\uc774 \uc548\uba39\ud78c\ub2e4. \ubcf4\uba74 systemctl \uba85\ub839\uc744 \uc0ac\uc6a9 \ud558\ub77c\uace0 \ud55c\ub2e4.. \uadf8\ub9ac\uace0 \uae30\uc874\uc5d0 \ubd80\ud305\ub54c \uc11c\ube44\uc2a4\ub97c \uc790\ub3d9 \uc2e4\ud589 \ud558\ub3c4\ub85d \ub4f1\ub85d \ud558\ub294 \uba85\ub839\uc778 chkconfig\ub3c4 systemctl \uc5d0 \ud3ec\ud568\uc774 \ub410\ub2e4.. \uc0ac\uc6a9 \ubc29\ubc95\uc740 \ucd08 \uac04\ub2e4.. service \uc11c\ube44\uc2a4\uba85 start \u00a0 \u00a0=> systemctl start \uc11c\ube44\uc2a4\uba85 service \uc11c\ube44\uc2a4\uba85 restart \u00a0 \u00a0=>\u2026","rel":"","context":"In &quot;\uae30\uc220\uc790\ub8cc&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":538,"url":"https:\/\/blog.box.kr\/?p=538","url_meta":{"origin":647,"position":5},"title":"[\ud38c]\uac00\uc0c1\uba38\uc2e0\uc5d0 Android \uc124\uce58 \ud558\uc5ec adb \uc5f0\uacb0 \ud558\uae30","date":"2015-01-05","format":false,"excerpt":"1. VMWare\uac74 VirtualBox\uac74 \uc0c1\uad00\uc5c6\ub2e4. VM\ud638\uc2a4\ud2b8\ub97c \uc900\ube44\ud558\uc790. 2.\u00a0http:\/\/www.android-x86.org\/download \ub85c \uac00\uc11c\u00a0Deprecated x86 2.2 generic\u00a0\uc744 \ubc1b\uc790. Q) \uc65c Deprecated \uc778 2.2 generic \uc744 \ubc1b\ub098\uc694. Deprecated\ub294 \uc4f0\uba74 \uc548\ub418\ub294 \uac70 \uc544\ub2d8? A) http:\/\/mariuz.android-dev.ro\/vm.iso.7z \ub3c4 \uc788\ub2e4\uace0 \ud55c\ub2e4.\u00a0http:\/\/www.android-x86.org\/download \uc5d0 \uc788\ub294 \uc694\uc998 \uac83\ub4e4\uc740 \uc8c4\ub2e4 \uc548\ub41c\ub2e4. 3. \uc8c4\ub2e4 \uc77c\ub2e8 Default \uc124\uc815\uc5d0 yes yes \ud558\uace0 \uc124\uce58\ud55c\ub2e4. \ud55c\uae00 \ubb38\uc11c\uac00 \ud544\uc694\ud55c \ubd84\uc740\u2026","rel":"","context":"In &quot;\uae30\uc220\uc790\ub8cc&quot;","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/1.bp.blogspot.com\/-R8uOK6LYepI\/T0ad0iQ_IPI\/AAAAAAAAFJY\/YuMYSVCsToA\/s320\/%E1%84%89%E1%85%B3%E1%84%8F%E1%85%B3%E1%84%85%E1%85%B5%E1%86%AB%E1%84%89%E1%85%A3%E1%86%BA+2012-02-24+%E1%84%8B%E1%85%A9%E1%84%8C%E1%85%A5%E1%86%AB+5.12.04.png?resize=350%2C200","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/647"}],"collection":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=647"}],"version-history":[{"count":0,"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/647\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=647"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=647"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=647"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}