{"id":1990,"date":"2014-02-14T14:59:25","date_gmt":"2014-02-14T14:59:25","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=1990"},"modified":"2017-01-27T11:14:59","modified_gmt":"2017-01-27T02:14:59","slug":"sqlite%ec%97%90%ec%84%9c-%eb%aa%87%ea%b0%80%ec%a7%80-sql-%eb%ac%b8-%ec%a0%95%eb%a6%ac","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=1990","title":{"rendered":"SQLite\uc5d0\uc11c \uba87 \uac00\uc9c0 SQL \ubb38 \uc815\ub9ac"},"content":{"rendered":"<p>SQLite\uc5d0\uc11c \uba87\uac00\uc9c0 \ud544\uc694\ud55c SQL \ubb38\uc744 \ucc3e\uc544 \uc815\ub9ac\ud574 \ubd05\ub2c8\ub2e4. \uae30\uc874\uc758 SHP \ud30c\uc77c\uc758 \uc18d\uc131 \uc815\ubcf4\ub97c DBF \ud30c\uc77c\uc744 \ud1b5\ud574 \uc0ac\uc6a9\ud588\uc73c\ub098 \uba87\uac00\uc9c0 \uc911\uc694\ud55c \uc774\uc720\ub85c \uc778\ud574 SHP \ud30c\uc77c\uc758 \uc18d\uc131\uc744 DBF \ud30c\uc77c\uc774 \uc544\ub2cc SQLite\ub85c \ub300\uccb4\ud558\uace0\uc790 \ud568\uc778\ub370\uc694. SQLite\uc758 DB\uac00 \uac16\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc7a5\uc810\uc744 \uac16\uace0\uc790 \ud568\uc785\ub2c8\ub2e4.<\/p>\n<p><UL><LI>DB\uac00 \ub2e8 \ud558\ub098\uc758 \ud30c\uc77c\ub85c \uad6c\uc131\ub418\uc5b4 \uc788\uc5b4\uc11c SHP \ud30c\uc77c\uacfc \ud568\uaed8 \uc27d\uac8c \uc804\ub2ec\uc774 \uac00\ub2a5\ud568<\/LI><LI>SQL\ubb38\uc758 WHERE \uc808\uc744 \ud1b5\ud55c \ub2e4\uc591\ud55c \uac80\uc0c9 \uc870\uac74\uc744 \uc904 \uc218 \uc788\uc74c<\/LI><LI>Index\ub97c \uac78\uc5b4 \ube60\ub978 \uac80\uc0c9\uc774 \uac00\ub2a5\ud568<\/LI><LI>\uc18d\uc131 \uac12\uc744 SQL\uc758 UPDATE \ubb38\uc744 \ud1b5\ud574 \uc27d\uac8c \ud560 \uc218 \uc788\uc74c<\/LI><\/UL><\/p>\n<p>SQLite\uc758 DB \ud30c\uc77c\uc744 DBF \ud30c\uc77c \ub300\uc2e0 \uc0ac\uc6a9\ud558\uae30 \uc704\ud574 \uae30\ubcf8\uc801\uc73c\ub85c \ud30c\uc545\ud574\uc57c\ud560 SQL \ubb38\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. \uba3c\uc800 SQLite \ud30c\uc77c\uc5d0 \uc874\uc7ac\ud558\ub294 \ud14c\uc774\ube14\uc758 \uc774\ub984\uc744 \uc5bb\uae30 \uc704\ud55c SQL \ubb38\uc785\ub2c8\ub2e4.<\/p>\n<pre>\r\nSELECT name FROM sqlite_master WHERE type = 'table'\r\n<\/pre>\n<p>\uc704\uc758 SQL\ubb38\uc758 \uc2e4\ud589 \uacb0\uacfc\uc5d0 \ub300\ud55c \uc608\ub294 \uc544\ub798 \uadf8\ub9bc\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1058691612.png\" width=\"433\" height=\"159\" alt=\"\uc0ac\uc6a9\uc790 \uc0bd\uc785 \uc774\ubbf8\uc9c0\" title=\"\" \/><\/p>\n<p>\ub2e4\uc74c\uc740 \ud2b9\uc815 \ud14c\uc774\ube14\uc744 \uad6c\uc131\ud558\ub294 \ud544\ub4dc\uc758 \uc774\ub984\uacfc \ud0c0\uc785\uc744 \uc5bb\ub294 SQL \ubb38\uc785\ub2c8\ub2e4.<\/p>\n<pre>\r\npragma table_info(TL_SCCO_EMD)\r\n<\/pre>\n<p>\uc0ac\uc2e4 \uc704\ub294 \uba85\ub839\uc740 SQL \ubb38\uc774 \uc544\ub2d9\ub2c8\ub2e4. \uc5ec\ud2bc \uc704\uc758 \uacb0\uacfc\uc5d0 \ub300\ud55c \uc608\ub294 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1135941788.png\" width=\"489\" height=\"219\" alt=\"\uc0ac\uc6a9\uc790 \uc0bd\uc785 \uc774\ubbf8\uc9c0\" title=\"\" \/><\/p>\n<p>\uadf8\ub9ac\uace0 \ud574\ub2f9 \ud14c\uc774\ube14\uc758 \ub808\ucf54\ub4dc \uac1c\uc218\ub97c \uc5bb\ub294 SQL\ubb38\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre>\r\nSELECT COUNT(*) FROM TL_SCCO_EMD\r\n<\/pre>\n<p>\uc704\uc758 SQL \ubb38\uc758 \uacb0\uacfc\uc5d0 \ub300\ud55c \uc608\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.gisdeveloper.co.kr\/wp-content\/uploads\/1\/1056238828.png\" width=\"483\" height=\"159\" alt=\"\uc0ac\uc6a9\uc790 \uc0bd\uc785 \uc774\ubbf8\uc9c0\" title=\"\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQLite\uc5d0\uc11c \uba87\uac00\uc9c0 \ud544\uc694\ud55c SQL \ubb38\uc744 \ucc3e\uc544 \uc815\ub9ac\ud574 \ubd05\ub2c8\ub2e4. \uae30\uc874\uc758 SHP \ud30c\uc77c\uc758 \uc18d\uc131 \uc815\ubcf4\ub97c DBF \ud30c\uc77c\uc744 \ud1b5\ud574 \uc0ac\uc6a9\ud588\uc73c\ub098 \uba87\uac00\uc9c0 \uc911\uc694\ud55c \uc774\uc720\ub85c \uc778\ud574 SHP \ud30c\uc77c\uc758 \uc18d\uc131\uc744 DBF \ud30c\uc77c\uc774 \uc544\ub2cc SQLite\ub85c \ub300\uccb4\ud558\uace0\uc790 \ud568\uc778\ub370\uc694. SQLite\uc758 DB\uac00 \uac16\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc7a5\uc810\uc744 \uac16\uace0\uc790 \ud568\uc785\ub2c8\ub2e4. DB\uac00 \ub2e8 \ud558\ub098\uc758 \ud30c\uc77c\ub85c \uad6c\uc131\ub418\uc5b4 \uc788\uc5b4\uc11c SHP \ud30c\uc77c\uacfc \ud568\uaed8 \uc27d\uac8c \uc804\ub2ec\uc774 \uac00\ub2a5\ud568SQL\ubb38\uc758 WHERE \uc808\uc744 \ud1b5\ud55c \ub2e4\uc591\ud55c \uac80\uc0c9 &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=1990\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;SQLite\uc5d0\uc11c \uba87 \uac00\uc9c0 SQL \ubb38 \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":[],"class_list":["post-1990","post","type-post","status-publish","format-standard","hentry","category-programming"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1990","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=1990"}],"version-history":[{"count":2,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1990\/revisions"}],"predecessor-version":[{"id":2893,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1990\/revisions\/2893"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1990"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1990"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1990"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}