{"id":1103,"date":"2010-02-22T14:55:05","date_gmt":"2010-02-22T14:55:05","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=1103"},"modified":"2017-01-29T09:30:40","modified_gmt":"2017-01-29T00:30:40","slug":"mysql-%ed%84%b0%eb%af%b8%eb%84%90-%eb%aa%a8%eb%8b%88%ed%84%b0-%ec%82%ac%ec%9a%a9-%ec%a0%95%eb%a6%ac","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=1103","title":{"rendered":"MySql \ud130\ubbf8\ub110 \ubaa8\ub2c8\ud130 \uc0ac\uc6a9 \uc815\ub9ac"},"content":{"rendered":"<p>\uc774 \ubb38\uc11c\ub294 MySQL\uc744 \uc124\uce58\ud558\uba74 \uc81c\uacf5\ub418\ub294 \ud130\ubbf8\ub110 \ubaa8\ub2c8\ud130\uc758 \uc0ac\uc6a9\ubc95\uc744 \uac04\ub2e8\ud788 \uc815\ub9ac\ud55c \uac83\uc785\ub2c8\ub2e4. \uac00\uc7a5 \uba3c\uc800 \uc11c\ubc84\uc5d0 \uc5f0\uacb0\ud558\ub294 \ubc29\ubc95\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre>c:\\&gt;mysql -h localhost -u root -p\r\nEnter password: ******<\/pre>\n<p>\uc258\uc5d0\uc11c mysql \uba85\ub839\uc744 \ud1b5\ud574 \uc778\uc790 -h\uc5d0\ub294 \ud638\uc2a4\ud2b8(\uc5ec\uae30\uc11c\ub294 localhost\ub97c \uc9c0\uc815\ud588\uc73c\uba70 \ub85c\uceec\uc77c\ub54c\ub294 \uc0dd\ub7b5\uc774 \uac00\ub2a5)\ub97c \uc81c\uacf5\ud558\uba70 -u\uc5d0\ub294 \uc0ac\uc6a9\uc790\uc758 ID(\uc5ec\uae30\uc11c\ub294 root)\ub97c \uc81c\uacf5\ud558\uace0 \ub9c8\uc9c0\ub9c9\uc73c\ub85c -p \uc635\uc158\uc744 \uc8fc\uc5b4 \ud328\uc2a4\uc6cc\ub4dc\ub97c \uc785\ub825\ubc1b\uc744 \uc218 \uc788\ub3c4\ub85d \ud569\ub2c8\ub2e4.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1404376372.jpg\" alt=\"\uc0ac\uc6a9\uc790 \uc0bd\uc785 \uc774\ubbf8\uc9c0\" width=\"504\" height=\"151\" \/><br \/>\n\ud328\uc2a4\uc6cc\ub4dc\ub97c \uc62c\ubc14\ub974\uac8c \uc785\ub825\ud558\uace0 \ubaa8\ub4e0 \uac83\uc774 \uc131\uacf5\ud558\uba74 \uc704\uc758 \uadf8\ub9bc\ucc98\ub7fc mysql&gt;\uac00 \ub728\uace0 \uba85\ub839\uc744 \uc785\ub825\ud560 \uc218 \uc788\ub294 \uc0c1\ud0dc\uac00 \ub429\ub2c8\ub2e4. \ucc38\uace0\ub85c \uc5f0\uacb0\uc744 \ub04a\ub294 \ubc29\ubc95\uc740 quit \uba85\ub839\uc744 \ub0b4\ub824 \uc885\ub8cc\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc2dc\ud5d8 \uc0bc\uc544 \ub2e4\uc74c \uba85\ub839\uc744 \ub0b4\ub824 MySQL\uc758 \uae30\ub2a5\uc744 \ud14c\uc2a4\ud2b8\ud574 \ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<pre>\r\nSELECT VERSION(), CURRENT_DATE;\r\nSELECT SIN(PI()\/4), (4+1)*4;\r\nSELECT NOW();<\/pre>\n<p>\uc774 \uc138 \uba85\ub839\uc5d0 \ub300\ud55c \uacb0\uacfc\ub294 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1124436986.jpg\" alt=\"\uc0ac\uc6a9\uc790 \uc0bd\uc785 \uc774\ubbf8\uc9c0\" width=\"373\" height=\"378\" \/><br \/>\n\ucc38\uac00\ub85c \uba85\ub839\uc5b4 \uc785\ub825 \ub3c4\uc911\uc5d0 \ucde8\uc18c\ub97c \ud558\uace0\uc790 \ud55c\ub2e4\uba74 \\c\ub97c \uc785\ub825\ud558\uace0 \uc5d4\ud130\ud0a4\ub97c \ub204\ub974\uba74 \ub429\ub2c8\ub2e4. \uc815\ub9ac\ud558\uba74 \uba85\ub839\uc5b4\ub294 \ub300\uc18c\ubb38\uc790\ub97c \uad6c\ubd84\ud558\uc9c0 \uc54a\uc73c\uba70 \ub05d\uc740 \ubc18\ub4dc\uc2dc ; \uc73c\ub85c \ub05d\ub098\uc57c \ud569\ub2c8\ub2e4.<\/p>\n<p>\uc774\uc81c \ub2e4\uc74c\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0dd\uc131\ud558\ub294 \uba85\ub839\uc785\ub2c8\ub2e4.<\/p>\n<pre>CREATE DATABASE XrGeoDatabase<\/pre>\n<p>\uc9c0\uae08\uae4c\uc9c0 \uc0dd\uc131\ub418\uc5b4\uc9c4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ubaa9\ub85d\uc744 \uc0b4\ud3b4\ubcf4\ub294 \uba85\ub839\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre>SHOW DATABASES;<\/pre>\n<p>\uc774 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc911\uc5d0 \uc0ac\uc6a9\ud560 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc120\ud0dd\ud558\ub294 \uba85\ub839\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre>USE XrGeoDatabase;<\/pre>\n<p>\uc544\ub798\ub294 \uc704\uc5d0\uc11c \uc0c8\ub86d\uac8c \ubcf4\uc778 \uc138\uac1c\uc758 \uba85\ub839\uc744 \uc21c\ucc28\uc801\uc73c\ub85c \ub0b4\ub824 MySQL\uc5d0\uc11c \ucc98\ub9ac\ub41c \uacb0\uacfc \ud654\uba74\uc785\ub2c8\ub2e4.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1350604246.jpg\" alt=\"\uc0ac\uc6a9\uc790 \uc0bd\uc785 \uc774\ubbf8\uc9c0\" width=\"455\" height=\"265\" \/><br \/>\n\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ub300\ud55c \uba85\ub839\uc73c\ub85c\uc368 \uc0ad\uc81c\uc5d0 \ub300\ud55c \uac83\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre>DROP DATABASE XrGeoDatabase;<\/pre>\n<p>\uc774\uc81c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc120\ud0dd\ud588\uace0 \uc774 \uc120\ud0dd\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc548\uc5d0 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\ub294 \uba85\ub839\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre>CREATE TABLE tablename (\r\n\u00a0 \u00a0 column_name1 INT,\r\n\u00a0 \u00a0 column_name2 VARCHAR(15),\r\n\u00a0 \u00a0 column_name3 INT );<\/pre>\n<p>\ud14c\uc774\ube14\uc774 \uc798 \uc0dd\uc131\ub418\uc5c8\ub294\uc9c0 \uc120\ud0dd\ub41c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc874\uc7ac\ud558\ub294 \ud14c\uc774\ube14\uc758 \ubaa9\ub85d\uc744 \uc0b4\ud3b4\ubcf4\ub294 \uba85\ub839\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre>SHOW TABLES;<\/pre>\n<p>\ud2b9\uc815 \ud14c\uc774\ube14\uc5d0 \ub300\ud55c \ud14c\uc774\ube14 \uc2a4\ud0a4\ub9c8\ub97c \uc0b4\ud3b4\ubcf4\ub294 \uba85\ub839\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre>EXPLAIN tablename;<\/pre>\n<p>\uc544\ub798\uc758 \uadf8\ub9bc\uc740 \uc704\uc758 \uc138\uac00\uc9c0 \uba85\ub839\uc744 \uc21c\uc11c\ub300\ub85c \uc218\ud589\ud55c \uac83\uc5d0 \ub300\ud55c \ud654\uba74\uc758 \uacb0\uacfc\uc785\ub2c8\ub2e4.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1154565808.jpg\" alt=\"\uc0ac\uc6a9\uc790 \uc0bd\uc785 \uc774\ubbf8\uc9c0\" width=\"506\" height=\"373\" \/><br \/>\n\ucc38\uace0\ub85c \ud14c\uc774\ube14\uc758 \uc774\ub984\uc744 \ubcc0\uacbd\ud558\ub294 \uba85\ub839\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre>RENAME TABLE tablename TO other_tablename;<\/pre>\n<p>\uadf8\ub9ac\uace0 \ud544\uc694\ud558\uc9c0 \uc54a\uc740 \ud14c\uc774\ube14\uc744 \uc0ad\uc81c\ud558\ub294 \uba85\ub839\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre>DROP TABLE tablename;<\/pre>\n<p>MySQL\uc740 \uc0ac\uc6a9\uc790\uac00 \uc791\uc5c5\ud558\ub294 \uacfc\uc815\uc758 \uc0c1\ud0dc \uc815\ubcf4\ub97c \uc81c\uacf5\ud558\uae30 \uc704\ud574 status \uba85\ub839\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \ub610\ud55c \uba85\ub839 \ucc98\ub9ac\uc5d0 \ub300\ud574 \uc624\ub958\ub098 \uacbd\uace0\uac00 \ubc1c\uc0dd\ud560 \uacbd\uc6b0 \uadf8 \uba54\uc138\uc9c0\ub97c \ub2e4\uc2dc \ubcf4\uae30 \uc704\ud574 show errors\uc640 show warnings \uba85\ub839\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc774\uc678\uc5d0 \ub370\uc774\ud130\ub97c \ucffc\ub9ac\ud558\uace0 \ub808\ucf54\ub4dc\ub97c \ucd94\uac00\ud558\uace0 \ubcc0\uacbd\ud558\ub294 \ub4f1\uc758 SQL\ubb38\uc5d0 \ub300\ud574 \uac04\ub2e8\ud55c \uc608\ub97c \ud1b5\ud574 \ubcf4\uc774\uace0 \ub9c8\ubb34\ub9ac \ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ud14c\uc774\ube14\ub85c\ubd80\ud130 \uc9c0\uc815\ud55c \ud544\ub4dc\ub4e4\uc5d0 \ub300\ud55c \uac12\uc744 \ucffc\ub9ac\ud558\ub294 \uba85\ub839<\/p>\n<pre>SELECT col1, col2 FROM tablename;<\/pre>\n<p>\ub808\ucf54\ub4dc\ub97c \ucd94\uac00\ud558\ub294 \uba85\ub839<\/p>\n<pre>INSERT INTO tablename VALUES (value1, value2);<\/pre>\n<p>\uc870\uac74\uc5d0 \ub9de\ub294 \ub808\ucf54\ub4dc\uc758 \uac12\uc744 \ubcc0\uacbd\ud558\ub294 \uba85\ub839<\/p>\n<pre>UPDATE tablename SET col1=newValue WHERE col2=value;<\/pre>\n<p>\ub808\ucf54\ub4dc\ub97c \uc0ad\uc81c\ud558\ub294 \uba85\ub839<\/p>\n<pre>DELETE FROM tablename WHERE col2=value;<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\uc774 \ubb38\uc11c\ub294 MySQL\uc744 \uc124\uce58\ud558\uba74 \uc81c\uacf5\ub418\ub294 \ud130\ubbf8\ub110 \ubaa8\ub2c8\ud130\uc758 \uc0ac\uc6a9\ubc95\uc744 \uac04\ub2e8\ud788 \uc815\ub9ac\ud55c \uac83\uc785\ub2c8\ub2e4. \uac00\uc7a5 \uba3c\uc800 \uc11c\ubc84\uc5d0 \uc5f0\uacb0\ud558\ub294 \ubc29\ubc95\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. c:\\&gt;mysql -h localhost -u root -p Enter password: ****** \uc258\uc5d0\uc11c mysql \uba85\ub839\uc744 \ud1b5\ud574 \uc778\uc790 -h\uc5d0\ub294 \ud638\uc2a4\ud2b8(\uc5ec\uae30\uc11c\ub294 localhost\ub97c \uc9c0\uc815\ud588\uc73c\uba70 \ub85c\uceec\uc77c\ub54c\ub294 \uc0dd\ub7b5\uc774 \uac00\ub2a5)\ub97c \uc81c\uacf5\ud558\uba70 -u\uc5d0\ub294 \uc0ac\uc6a9\uc790\uc758 ID(\uc5ec\uae30\uc11c\ub294 root)\ub97c \uc81c\uacf5\ud558\uace0 \ub9c8\uc9c0\ub9c9\uc73c\ub85c -p \uc635\uc158\uc744 \uc8fc\uc5b4 \ud328\uc2a4\uc6cc\ub4dc\ub97c \uc785\ub825\ubc1b\uc744 \uc218 \uc788\ub3c4\ub85d \ud569\ub2c8\ub2e4. \ud328\uc2a4\uc6cc\ub4dc\ub97c &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=1103\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;MySql \ud130\ubbf8\ub110 \ubaa8\ub2c8\ud130 \uc0ac\uc6a9 \uc815\ub9ac&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[59],"class_list":["post-1103","post","type-post","status-publish","format-standard","hentry","category-programming","tag-mysql"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1103","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1103"}],"version-history":[{"count":1,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1103\/revisions"}],"predecessor-version":[{"id":3369,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1103\/revisions\/3369"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1103"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1103"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}