{"id":345,"date":"2014-08-17T17:14:52","date_gmt":"2014-08-18T02:14:52","guid":{"rendered":"http:\/\/blog.box.kr\/?p=345"},"modified":"2014-08-17T17:14:52","modified_gmt":"2014-08-18T02:14:52","slug":"alter-table-%ec%bb%ac%eb%9f%bc-%ec%82%ac%ec%9d%b4%ec%a6%88-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ed%81%ac%ea%b8%b0-%ec%a1%b0%ec%a0%95","status":"publish","type":"post","link":"https:\/\/blog.box.kr\/?p=345","title":{"rendered":"Alter Table [ \uceec\ub7fc \uc0ac\uc774\uc988, \ub370\uc774\ud130 \ud06c\uae30 \uc870\uc815 ]"},"content":{"rendered":"<p>[DB2] \ucef4\ub7fc\uc758 \ub370\uc774\ud130 \ud0c0\uc785 \ub610\ub294 \uc0ac\uc774\uc988 \uc870\uc815<br \/>\n<span class=\"kwd\" style=\"color: #00008b;\">ALTER<\/span><span class=\"kwd\" style=\"color: #00008b;\">TABLE<\/span><span class=\"pln\"> temp<br \/>\n<\/span><span class=\"pln\">\u00a0 \u00a0\u00a0<\/span><span class=\"kwd\" style=\"color: #00008b;\">ALTER<\/span><span class=\"kwd\" style=\"color: #00008b;\">COLUMN<\/span><span class=\"pln\"> col1 <\/span><span class=\"kwd\" style=\"color: #00008b;\">SET<\/span><span class=\"pln\"> DATA TYPE VARCHAR<\/span><span class=\"pun\">(<\/span><span class=\"lit\" style=\"color: #800000;\">60<\/span><span class=\"pun\">);<\/span><\/p>\n<p>[ORACLE]<br \/>\n<span style=\"color: #000000;\">alter table<\/span><br style=\"color: #000000;\" \/><span style=\"color: #000000;\">\u00a0\u00a0 table_name<\/span><br style=\"color: #000000;\" \/><span style=\"color: #000000;\">modify<\/span><br style=\"color: #000000;\" \/><span style=\"color: #000000;\">\u00a0\u00a0 column_name\u00a0 datatype;<\/span><br \/>\n\uc774\ub7f0\uc2dd\uc73c\ub85c\ub3c4 \ub41c\ub2e4..<br \/>\n<span style=\"color: #000000;\">alter table<\/span><br style=\"color: #000000;\" \/><span style=\"color: #000000;\">\u00a0\u00a0 table_name<\/span><br style=\"color: #000000;\" \/><span style=\"color: #000000;\">modify<\/span><br style=\"color: #000000;\" \/><span style=\"color: #000000;\">\u00a0\u00a0 (<\/span><br style=\"color: #000000;\" \/><span style=\"color: #000000;\">\u00a0\u00a0 column1_name\u00a0 column1_datatype,<\/span><br style=\"color: #000000;\" \/><span style=\"color: #000000;\">\u00a0\u00a0 column2_name\u00a0 column2_datatype,<\/span><br style=\"color: #000000;\" \/><span style=\"color: #000000;\">\u00a0\u00a0 column3_name\u00a0 column3_datatype,<\/span><br style=\"color: #000000;\" \/><span style=\"color: #000000;\">\u00a0\u00a0 column4_name\u00a0 column4_datatype<\/span><br style=\"color: #000000;\" \/><span style=\"color: #000000;\">\u00a0\u00a0 );<\/span><\/p>\n<p>[MYSQL]<br \/>\nalter table <i>people<\/i> modify <i>name<\/i> VARCHAR(35) ;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[DB2] \ucef4\ub7fc\uc758 \ub370\uc774\ud130 \ud0c0\uc785 \ub610\ub294 \uc0ac\uc774\uc988 \uc870\uc815 ALTERTABLE temp \u00a0 \u00a0\u00a0ALTERCOLUMN col1 SET DATA TYPE VARCHAR(60); [ORACLE] alter table\u00a0\u00a0 table_namemodify\u00a0\u00a0 column_name\u00a0 datatype; \uc774\ub7f0\uc2dd\uc73c\ub85c\ub3c4 \ub41c\ub2e4.. alter table\u00a0\u00a0 table_namemodify\u00a0\u00a0 (\u00a0\u00a0 column1_name\u00a0 column1_datatype,\u00a0\u00a0 column2_name\u00a0 column2_datatype,\u00a0\u00a0 column3_name\u00a0 column3_datatype,\u00a0\u00a0 column4_name\u00a0 column4_datatype\u00a0\u00a0 ); [MYSQL] alter table people modify name VARCHAR(35) ;<\/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":[12],"tags":[],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5q9Zn-5z","jetpack-related-posts":[{"id":647,"url":"https:\/\/blog.box.kr\/?p=647","url_meta":{"origin":345,"position":0},"title":"MYSQL\uc5d0\uc11c AUTO INCREMENT column\uc758 \uc785\ub825 \uac12 \uac00\uc838\uc624\uae30..","date":"2015-04-05","format":false,"excerpt":"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; \u00a0 \uc774\ub807\uac8c \ud558\uba74 \ub41c\ub2e4. \u00a0","rel":"","context":"In &quot;\uae30\uc220\uc790\ub8cc&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":164,"url":"https:\/\/blog.box.kr\/?p=164","url_meta":{"origin":345,"position":1},"title":"\ud504\ub85c\uc138\uc2a4 \uac04\uc758 \ud1b5\uc2e0","date":"2014-07-08","format":false,"excerpt":"\ud504\ub85c\uc138\uc2a4 \uac04\uc758 \ud1b5\uc2e0(IPC)\uc740 \ud504\ub85c\uc138\uc2a4 \uac04\uc5d0 \uc815\ubcf4\ub97c \uc8fc\uace0 \ubc1b\uc744 \uc218 \uc788\ub3c4\ub85d \ud558\ub294 \ud1b5\uc2e0 \uae30\ubc95\uc785\ub2c8\ub2e4. \ud504\ub85c\uc138\uc2a4 \uac04\uc758 \ud1b5\uc2e0 \ubc29\ubc95\uc740 \uc11c\ub85c \uac04\uc5d0 \uba54\uc2dc\uc9c0\ub97c \uc804\ub2ec\ud558\ub294 \ubc29\ubc95\uacfc \uacf5\uc720 \uba54\ubaa8\ub9ac\ub97c \uc774\uc6a9\ud558\ub294 \ubc29\ubc95 \uadf8\ub9ac\uace0 \ud074\ub9bd\ubcf4\ub4dc\ub97c \uc774\uc6a9\ud558\ub294 \ubc29\ubc95 \ub4f1\uc774 \uc788\uc2b5\ub2c8\ub2e4. 1. \ud504\ub85c\uc138\uc2a4 \uc0ac\uc774\uc758 \uba54\uc2dc\uc9c0 \uc804\ub2ec 1)\ub3d9\uc77c\ud55c \ud504\ub85c\uadf8\ub7a8\uc774 \uc5ec\ub7ec \uac1c \uc2e4\ud589 \uc911\uc77c \ub54c \uba54\uc2dc\uc9c0 \uc804\uc1a1 RegisterWindowMessage \uc774\uc6a9 \ud504\ub85c\uc138\uc2a4 \ub610\ub294\u2026","rel":"","context":"In &quot;MFC &amp; WINDOWS&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":809,"url":"https:\/\/blog.box.kr\/?p=809","url_meta":{"origin":345,"position":2},"title":"[scrap] Replication Startup Options","date":"2015-05-18","format":false,"excerpt":"http:\/\/simonshin.egloos.com\/2247545 \u00a0 \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 \uc2a4\ud0c0\ud2b8\uc5c5 \uc635\uc158\ub4e4 \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \uc5ec\ub7ec\ubd84\uc774 \uc2ac\ub808\uc774\ube0c \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 \uc11c\ubc84\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc635\uc158\ub4e4\uc5d0 \ub300\ud574 \uc124\uba85\ud558\uae30\ub85c \ud55c\ub2e4. \uc774 \uc635\uc158\ub4e4\uc740 \uba85\ub839\uc5b4 \ub77c\uc778 \ub610\ub294 \uc635\uc158 \ud30c\uc77c\uc5d0\uc11c \uc9c0\uc815\ud560 \uc218 \uc788\ub2e4. \ub9c8\uc2a4\ud130\uc640 \uac01 \uc2ac\ub808\uc774\ube0c\uc5d0\uc11c, \uc5ec\ub7ec\ubd84\uc740 \uace0\uc720\uc758 \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 ID\ub97c \uc124\uc815\ud558\uae30 \uc704\ud574\uc11c \ubc18\ub4dc\uc2dc server-id\uc635\uc158\uc744 \uc0ac\uc6a9\ud574\uc57c \ud55c\ub2e4. \uac01 \uc11c\ubc84\uc758 \uacbd\uc6b0, \uc5ec\ub7ec\ubd84\uc740 1 \uc5d0\uc11c 232 \u2013 1\u2026","rel":"","context":"In &quot;DB\uad00\ub828&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":162,"url":"https:\/\/blog.box.kr\/?p=162","url_meta":{"origin":345,"position":3},"title":"[Tip] WM_COPYDATA \uba54\uc2dc\uc9c0\ub85c \ud504\ub85c\uadf8\ub7a8\uac04\uc5d0 \ub370\uc774\ud130 \uc8fc\uace0\ubc1b\ub294 \ubc29\ubc95","date":"2014-07-08","format":false,"excerpt":"\ud2b8\ub799\ubc31 \uc8fc\uc18c : http:\/\/www.tipssoft.com\/bulletin\/tb.php\/FAQ\/319 \ud301\uc2a4\uc18c\ud504\ud2b8\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 \ud504\ub85c\uadf8\ub798\ubc0d\uacfc \uad00\ub828\ub41c \uc790\ub8cc\ub098 \uc815\ubcf4\ub4e4\uc744 \ubb34\ub2e8\uc73c\ub85c \ubcf5\uc81c\ud558\uac70\ub098 \uac8c\uc7ac\ud558\ub294 \ud589\uc704\ub294 \uc0c1\ud638\uac04\uc758 \uc2e0\ub8b0\ub97c \ubb34\ub108\ub728\ub9ac\ub294 \ud589\uc704\uc774\uba70, \ubc95\uc801\uc778 \ubb38\uc81c\ub97c \uc57c\uae30\ud560 \uc218 \uc788\uc73c\ubbc0\ub85c \uac01\ubcc4\ud55c \uc8fc\uc758\ub97c \ub2f9\ubd80\ub4dc\ub9bd\ub2c8\ub2e4. * \ud301\uc2a4\uc18c\ud504\ud2b8 \uc800\uc791\uad8c \uc815\ucc45 \ubcf4\uae30 - http:\/\/www.tipssoft.com\/bulletin\/tb.php\/FAQ\/637 \uc774 \uc790\ub8cc\ub4e4\uc740 \ud301\uc2a4\uc18c\ud504\ud2b8\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 [ \uc54c\uc9dc\ubc30\uae30 ] \ud504\ub85c\uadf8\ub7a8\uc744 \uc774\uc6a9\ud558\uba74 \ub354 \ud3b8\ub9ac\ud558\uac8c \ubcfc\uc218 \uc788\uc2b5\ub2c8\ub2e4. * \uc54c\uc9dc\ubc30\uae30 \ud504\ub85c\uadf8\ub7a8 \ubc1b\uae30\u2026","rel":"","context":"In &quot;\uc77c\uc0c1&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":109,"url":"https:\/\/blog.box.kr\/?p=109","url_meta":{"origin":345,"position":4},"title":"\ub124\ud2b8\uc6cc\ud06c \ud2b8\ub798\ud53d\uc744 \uc904\uc774\uc790, Apache gzip \uc0ac\uc6a9","date":"2014-06-13","format":false,"excerpt":"XML, JSON \ubc29\uc2dd\uc73c\ub85c \ub370\uc774\ud130\ub97c \uc804\uc1a1\ud560 \ub54c \uadf8 \ud06c\uae30\uac00 1MB\uc774\uc0c1 \ub418\uba74 \uc804\uc1a1\uc2dc\uac04\uc774 \uc0c1\ub2f9\ud788 \ub9ce\uc774 \uac78\ub9ac\ub294 \uac83\uc744 \ubcfc \uc218 \uc788\ub2e4. \ub370\uc774\ud0c0 \ub7c9\uc774 \ub9ce\uc73c\uba74 \ud2b8\ub798\ud53d\uc774 \ub298\uc5b4\ub098\uace0 \ud2b9\ubcc4\ud788 \uc6f9\ud638\uc2a4\ud305\uc744 \ubc1b\ub294 \uc0ac\ub78c\ub4e4\uc5d0\uac8c\ub294 \ud2b8\ub798\ud53d\ub7c9\uc774 \ubc14\ub85c \uae08\uc804\uc801\uc778 \ubb38\uc81c\uc640 \uc5f0\uad00\uc774 \ub41c\ub2e4. \uc774 \ubb38\uc81c\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud574 \ub098\ub294 Apache\uc5d0\uc11c \uc9c0\uc6d0\ud558\ub294 gzip\uc744 \uc774\uc6a9\ud588\ub2e4. \ubb38\uc11c\ud30c\uc77c\uc740 Text\ud615\ud0dc\uc774\uae30 \uc555\ucd95\ud560 \uacbd\uc6b0 80%~90%\uc774\uc0c1\uc758 \uc555\ucd95\ub960\uc744 \ubcf4\uc778\ub2e4. \uc555\ucd95\ud574\uc11c\u2026","rel":"","context":"In &quot;Webserver&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1239,"url":"https:\/\/blog.box.kr\/?p=1239","url_meta":{"origin":345,"position":5},"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":[]}],"_links":{"self":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/345"}],"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=345"}],"version-history":[{"count":0,"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/345\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=345"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=345"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=345"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}