{"id":135,"date":"2011-02-14T23:34:06","date_gmt":"2011-02-14T23:34:06","guid":{"rendered":"http:\/\/mini.jellypo.pe.kr\/wp\/?p=135"},"modified":"2011-02-14T23:34:06","modified_gmt":"2011-02-14T23:34:06","slug":"openofficeorg-base-%ec%96%91%ec%8b%9d%ec%9d%84-%ec%9d%b4%ec%9a%a9%ed%95%b4-%eb%b3%b5%ec%88%98%ec%9d%98-%ed%85%8c%ec%9d%b4%eb%b8%94%ec%97%90-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9e%85%eb%a0%a5data-insert","status":"publish","type":"post","link":"https:\/\/mini.jellypo.pe.kr\/wp\/?p=135","title":{"rendered":"OpenOffice.org Base \uc591\uc2dd\uc744 \uc774\uc6a9\ud574 \ubcf5\uc218\uc758 \ud14c\uc774\ube14\uc5d0 \ub370\uc774\ud130 \uc785\ub825(data insert)"},"content":{"rendered":"

\"MS
MS Access\uc5d0\uc11c Table1, Table2 \ub450 \ud14c\uc774\ube14\uc5d0 \uc591\uc2dd(form)\uc744 \uc774\uc6a9\ud574 \uac12\uc744 \ub123\ub294 \ubaa8\uc2b5.
\nOpenOffice.org 3.3.0\uc5d0\uc120 \uc548\ub41c\ub2e4..<\/figcaption><\/figure>
\nOpenOffice.org Base \uc591\uc2dd\uc744 \uc774\uc6a9\ud574 \ubcf5\uc218\uc758 \ud14c\uc774\ube14\uc5d0 \ub370\uc774\ud130 \uc785\ub825(data insert)
\n<\/span>-> \uacb0\ub860 : 2011\ub144 2\uc6d4 15\uc77c \ud604\uc7ac OOo 3.3.0\uc73c\ub85c\ub294 Access\uc5d0\uc11c \ub418\ub294\uac8c \uc548\ub428.<\/span>
\n
\n1. \ud68c\uc0ac\uc11c \uc790\uc0b0\uad00\ub9ac\ub97c \uc5d1\uc140\ub85c \ud558\uace0 \uc788\ub2e4.<\/span>
\n2. \uac19\uc740 \ub370\uc774\ud130\ub97c \uac01\uac01 \ub2e4\ub978 \ubb38\uc11c\uc5d0 \uae30\ub85d\ud558\uace0 \uc788\ub2e4. \ub9ac\uc2a4\ud2b8, \uc774\ub825\uce74\ub4dc, \uad6c\uc131\ub3c4, IP \ub9ac\uc2a4\ud2b8…<\/span>
\n3. \uc5c5\ub370\uc774\ud2b8 \ud574\uc57c \ud560 \ubb38\uc11c\uac00 \ub9ce\uc74c.<\/span>
\n4. \ubb38\uc11c\uac00 \ub9ce\uc740\ub370 \ubb38\uc11c \uc5c5\ub370\uc774\ud2b8 \ub204\ub77d \ub418\uc5c8\uc744 \uacbd\uc6b0 \ud63c\ub780\uc744 \uc57c\uae30.<\/span><\/p>\n

\ud574\uacb0 \ubc29\ubc95\uc740 DataBase \ubfd0\uc774\ub780 \uacb0\ub860\uc744 \ub0b4\ub9ac\uace0 \uc194\ub8e8\uc158 \ud0d0\uc0c9 \uc2dc\uc791.<\/span><\/p>\n

\n\uc77c\ub2e8 \ub5a0\uc624\ub978 \uac83\uc740 Microsoft Access (MS \uc561\uc138\uc2a4)\uc640 \uc6f9 \uc1fc\ud551\ubab0.<\/span><\/p>\n

\n1. MS \uc194\ub8e8\uc158<\/span>
\n– DB : MS SQL<\/span>
\n– \uc785\ub825 \uc778\ud130\ud398\uc774\uc2a4 : MS Access<\/span><\/p>\n

2. \uc6f9 \uc194\ub8e8\uc158<\/span>
\n
\n– DB : MySQL \ub4f1<\/span>
\n
\n– \uc785\ub825 \uc778\ud130\ud398\uc774\uc2a4 : \uc6f9, php\ub97c \uc774\uc6a9\ud55c \uc0bd\uc9c8<\/span><\/p>\n

\n\ud604\ud589 \uc5c5\ubb34\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 \ubb38\uc11c \uc591\uc2dd\uc744 \ub9cc\ub4e4\uc5b4 \ucd9c\ub825\ud558\ub824\uba74 \uc6f9 \uc778\ud130\ud398\uc774\uc2a4\ub294 \uad49\uc7a5\ud788 \uacf5\uc774 \ub9ce\uc774 \ub4e4\uc5b4\uac04\ub2e4\ub294 \uacb0\ub860.<\/span><\/p>\n

\n\uadf8\ub7ec\ub098 \uc708\ub3c4 \uc11c\ubc84 \ub3cc\ub9b4 \ud558\ub4dc\uc6e8\uc5b4\uac00 \uc5c6\ub2e4.<\/span><\/p>\n

\ub300\uc548\uc73c\ub85c OpenOffice.org(\uc774\ud6c4 OOo)\ub098 LibreOffice\ub97c \ub5a0\uc62c\ub9ac\uace0 \uae30\ub2a5 \uac80\ud1a0\uc5d0 \ub4e4\uc5b4\uac10. \uc544\uc9c1\uae4c\uc9c4 \ub458\uc774 \uc774\ub984\ub9cc \ub2e4\ub974\uc9c0 \uae30\ub2a5\uc774\ub098 \ubc84\uadf8\uae4c\uc9c0 \uac19\ub354\ub77c.<\/span><\/p>\n

\n\uacb0\ub860 : 2011\ub144 2\uc6d4 15\uc77c \ud604\uc7ac OOo 3.3.0\uc73c\ub85c\ub294 Access\uc5d0\uc11c \ub418\ub294\uac8c \uc548\ub428.<\/span><\/p>\n

\nMS Access\uc5d0\uc11c \ub418\ub294 \uac83<\/span>
\n1. \ubcf5\uc218\uc758 \ud14c\uc774\ube14\uc744 \ubcf4\uc5ec\uc8fc\ub294 \ucffc\ub9ac \uc785\ub825<\/span>
\n2. \uc591\uc2dd(\uc785\ub825\ud3fc)\uc5d0\uc11c \ud574\ub2f9 \ucffc\ub9ac\ub97c \ubd88\ub7ec\ub0b4 \uc785\ub825<\/span>
\n3. \uc785\ub825\ud55c \uac01\uac01\uc758 \ud544\ub4dc \uac12\uc774 \ud574\ub2f9 \ud14c\uc774\ube14\uc5d0 \uc785\ub825<\/span><\/p>\n

\nOOo\uc5d0\uc120?<\/span>
\nMS Access\uc5d0\uc11c \uc9c0\uc6d0\ud558\ub294 view\ub098 query \ub97c \uc774\uc6a9\ud55c \ubcf5\uc218 \ud14c\uc774\ube14\uc5d0 \ub370\uc774\ud130 \uc0bd\uc785\uc744 Base\uc5d0\uc11c \uc544\uc9c1 \uc9c0\uc6d0\ud558\uc9c0 \uc54a\uc74c. view\ub098 query\ub294 \ud14c\uc774\ube14 \ubcf4\uae30\ub9cc \uac00\ub2a5.
\n<\/span><\/p>\n

http:\/\/user.services.openoffice.org\/en\/forum\/viewtopic.php?f=39&t=37451&sid=0cdb45823a1bbc64b044bbea9433c9f3<\/span><\/a><\/p>\n


\nSQL
\n<\/span>
\n
\nIn a form you can only use queries who give a result set. You can not
\ninsert data in other tables. When you need this queries then you have to
\n use the SQL tool.
\n<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

OpenOffice.org Base \uc591\uc2dd\uc744 \uc774\uc6a9\ud574 \ubcf5\uc218\uc758 \ud14c\uc774\ube14\uc5d0 \ub370\uc774\ud130 \uc785\ub825(data insert) -> \uacb0\ub860 : 2011\ub144 2\uc6d4 15\uc77c \ud604\uc7ac OOo 3.3.0\uc73c\ub85c\ub294 Access\uc5d0\uc11c \ub418\ub294\uac8c \uc548\ub428. 1. \ud68c\uc0ac\uc11c \uc790\uc0b0\uad00\ub9ac\ub97c \uc5d1\uc140\ub85c \ud558\uace0 \uc788\ub2e4. 2. \uac19\uc740 \ub370\uc774\ud130\ub97c \uac01\uac01 \ub2e4\ub978 \ubb38\uc11c\uc5d0 \uae30\ub85d\ud558\uace0 \uc788\ub2e4. \ub9ac\uc2a4\ud2b8, \uc774\ub825\uce74\ub4dc, \uad6c\uc131\ub3c4, IP \ub9ac\uc2a4\ud2b8… 3. \uc5c5\ub370\uc774\ud2b8 \ud574\uc57c \ud560 \ubb38\uc11c\uac00 \ub9ce\uc74c. 4. \ubb38\uc11c\uac00 \ub9ce\uc740\ub370 \ubb38\uc11c \uc5c5\ub370\uc774\ud2b8 \ub204\ub77d \ub418\uc5c8\uc744 \uacbd\uc6b0 \ud63c\ub780\uc744 […]<\/p>\n","protected":false},"author":1,"featured_media":136,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[85],"class_list":["post-135","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","tag-85"],"_links":{"self":[{"href":"https:\/\/mini.jellypo.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/135","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mini.jellypo.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mini.jellypo.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mini.jellypo.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mini.jellypo.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=135"}],"version-history":[{"count":0,"href":"https:\/\/mini.jellypo.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/135\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mini.jellypo.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/media\/136"}],"wp:attachment":[{"href":"https:\/\/mini.jellypo.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=135"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mini.jellypo.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=135"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mini.jellypo.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=135"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}