{"id":20484,"date":"2018-04-05T19:18:00","date_gmt":"2018-04-05T10:18:00","guid":{"rendered":"http:\/\/w3devlabs.net\/wp\/?p=20484"},"modified":"2018-03-22T20:18:31","modified_gmt":"2018-03-22T11:18:31","slug":"13-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-13-3-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-%ed%85%8c%ec%9d%b4%eb%b8%94-%ec%83%9d%ec%84%b1%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/w3devlabs.net\/wp\/?p=20484","title":{"rendered":"13. \ub370\uc774\ud130\ubca0\uc774\uc2a4 13.3 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud14c\uc774\ube14 \uc0dd\uc131\ud558\uae30"},"content":{"rendered":"

C\uae09 \uac1c\ubc1c\uc790\uc640 \ud568\uaed8\ud558\ub294 \ud30c\uc774\uc36c<\/h2>\n

13.3 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud14c\uc774\ube14 \uc0dd\uc131\ud558\uae30<\/font><\/font><\/span><\/h2>\n

\uc6b0\uc120 \uc5f0\uc2b5\uc744 \uc704\ud574\uc11c \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud574 \ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

\ud68c\uc6d0 \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uc5b4\uc11c \uc785\ub825, \uc218\uc815, \uc0ad\uc81c\ub97c \ud558\ub294\ubd80\ubd84\uc744 \ud504\ub85c\uadf8\ub798\ubc0d \ud574\ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uae30\ubcf8\uc801\uc73c\ub85c \uad00\ub9ac\uac00 \ud544\uc694\ud55c \uc815\ubcf4\ub97c \ub123\uc5b4\uc11c \uad00\ub9ac\ud558\ub294 \uc77c\uc744 \ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uc6b0\ub9ac\uac00 \ud68c\uc6d0\ud14c\uc774\ube14\uc744 \uc5b4\ub5bb\uac8c \ub9cc\ub4e4\uace0 \uc5b4\ub5bb\uac8c \ud14c\uc774\ube14 \uc815\uc758\ub97c \ud558\ub294\uc9c0 \uc54c\uc544\ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

\uc5ec\uae30\uc5d0\uc11c \ub098\uc624\ub294 \ubd80\ubd84\uc740 \ub300\ub2e8\ud788 \ubd80\ubd84\uc801\uc774\uae30 \ub54c\ubb38\uc5d0 \uc2e4\uc81c \ud504\ub85c\uadf8\ub7a8\uac1c\ubc1c\uc5d0\uc11c \uc870\uae08 \ub2e4\ub974\uac8c \ub9cc\ub4e4\uc5b4 \uc9c8\uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud559\uc2b5\uc744 \uc704\ud574\uc11c \uac04\ub7b5\ud558\uac8c \ub9cc\ub4e4\uc5c8\uc73c\ubbc0\ub85c \uc27d\uac8c \ubc30\uc6b0\uae30 \ubc14\ub78d\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

\ud68c\uc6d0\uc815\ubcf4\ub294 \ud68c\uc6d0\uc544\uc774\ub514, \ud68c\uc6d0\uc774\ub984, \ud68c\uc6d0\uc804\ud654\ubc88\ud638, \ud68c\uc6d0\uc774\uba54\uc77c 4\uac1c\uc758 \uc815\ubcf4\ub97c \uad00\ub9ac\ud574\ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. <\/font><\/span><\/p>\n



<\/p>\n

\ud68c\uc6d0\uc815\ubcf4\ub97c \uc704\ud574\uc11c \uc544\ub798\uc640 \uac19\uc740 \uc815\ubcf4\ub97c \uac00\uc9c0\uace0 \uc788\ub2e4\uace0 \uac00\uc815\ud569\ub2c8\ub2e4.<\/font><\/span><\/p>\n


<\/p>\n

\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n
\n

\ud68c\uc6d0\uc544\uc774\ub514<\/font><\/span><\/p>\n<\/td>\n

\n

\ud68c\uc6d0\uc774\ub984<\/font><\/span><\/p>\n<\/td>\n

\n

\ud68c\uc6d0\uc774\uba54\uc77c<\/font><\/span><\/p>\n<\/td>\n

\n

\ud68c\uc6d0\uc804\ud654\ubc88\ud638<\/font><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

gildong<\/font><\/span><\/p>\n<\/td>\n

\n

\ud64d\uae38\ub3d9<\/font><\/span><\/p>\n<\/td>\n

\n

gildong@testmail.com<\/font><\/span><\/p>\n<\/td>\n

\n

010-1111-1111<\/font><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

sunsin<\/font><\/span><\/p>\n<\/td>\n

\n

\uc774\uc21c\uc2e0<\/font><\/span><\/p>\n<\/td>\n

\n

sunsin@sunsin.com<\/font><\/span><\/p>\n<\/td>\n

\n

010-2222-2222<\/font><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

user1<\/font><\/span><\/p>\n<\/td>\n

\n

\uc774\uc720\uc8001<\/font><\/span><\/p>\n<\/td>\n

\n

user1@usermail.com<\/font><\/span><\/p>\n<\/td>\n

\n

010-3333-3333<\/font><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

user2<\/font><\/span><\/p>\n<\/td>\n

\n

\uc774\uc720\uc8002<\/font><\/span><\/p>\n<\/td>\n

\n

user2@usermail.com<\/font><\/span><\/p>\n<\/td>\n

\n

010-4444-4444<\/font><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n


<\/p>\n

\uc774 \uc815\ubcf4\ub97c \uc774\uc6a9\ud574\uc11c \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\ub824\uba74 \uc6b0\uc120 \ud14c\uc774\ube14\uba85\uc138\uc11c\ub97c \ub9cc\ub4e4\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/font><\/span><\/p>\n


<\/p>\n

\uc6b0\uc120 \ud14c\uc774\ube14 \uba85\uc138\uc11c\ub97c \ub9cc\ub4dc\ub294 \ubc29\ubc95\uc740 \uc6b0\ub9ac\uac00 \uad00\ub9ac\ud558\ub294 \ub370\uc774\ud130\uc758 \ud574\ub354\ub97c \uceec\ub7fc\uba85\uc73c\ub85c \ub9cc\ub4dc\ub294 \uac83\uc785\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

\n\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n
\n

\uceec\ub7fc\uba85<\/font><\/span><\/p>\n<\/td>\n

\n

\uceec\ub7fc\uc124\uba85<\/font><\/span><\/p>\n<\/td>\n

\n

\ub370\uc774\ud130\ud615<\/font><\/span><\/p>\n<\/td>\n

\n

\ud06c\uae30<\/font><\/span><\/p>\n<\/td>\n

\n

\ud0a4\uac12<\/font><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

USER_ID<\/font><\/span><\/p>\n<\/td>\n

\n

\ud68c\uc6d0\uc544\uc774\ub514<\/font><\/span><\/p>\n<\/td>\n

\n

varchar<\/font><\/span><\/p>\n<\/td>\n

\n

50<\/font><\/span><\/p>\n<\/td>\n

\n

PRIMARY KEY<\/font><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

USER_NAME<\/font><\/span><\/p>\n<\/td>\n

\n

\ud68c\uc6d0\uc774\ub984<\/font><\/span><\/p>\n<\/td>\n

\n

varchar<\/font><\/span><\/p>\n<\/td>\n

\n

50<\/font><\/span><\/p>\n<\/td>\n

\n

NOT NULL<\/font><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

USER_EMAIL<\/font><\/span><\/p>\n<\/td>\n

\n

\ud68c\uc6d0\uc774\uba54\uc77c<\/font><\/span><\/p>\n<\/td>\n

\n

varchar<\/font><\/span><\/p>\n<\/td>\n

\n

100<\/font><\/span><\/p>\n<\/td>\n

\n

NULL<\/font><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

USER_PHONE<\/font><\/span><\/p>\n<\/td>\n

\n

\ud68c\uc6d0\uc804\ud654\ubc88\ud638<\/font><\/span><\/p>\n<\/td>\n

\n

varchar<\/font><\/span><\/p>\n<\/td>\n

\n

20<\/font><\/span><\/p>\n<\/td>\n

\n

NULL<\/font><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\uac04\ub7b5\ud55c \ud14c\uc774\ube14 \uba85\uc138\uc11c<\/font><\/span><\/p>\n


<\/p>\n

\uc704\uc758 \ud14c\uc774\ube14 \uba85\uc138\uc11c\ub294 \uad00\ub9ac\ud558\ub294 \ub370\uc774\ud130\uc758 \ud574\ub354\ub97c \uceec\ub7fc\uc124\uba85\uc73c\ub85c \ub098\ud0c0\ub0c8\uc73c\uba74 \uc704\uc758 \uc815\ubcf4\ub97c \ubaa8\ub450 \uad00\ub9ac\ud560\uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

\ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uae30\uc704\ud55c \uc2a4\ud06c\ub9bd\ud2b8\ub294 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. CREATE \ubb38\uc744 \uc774\uc6a9\ud558\uc5ec \ud14c\uc774\ube14\uc744 \ub9cc\ub4dc\ub294 \uac83\uc785\ub2c8\ub2e4. <\/font><\/span><\/p>\n

<\/span><\/p>\n


<\/p>\n

\uc704 \ucffc\ub9ac\uc758 \uc2e4\ud589\uacb0\uacfc\ub294 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. \uc815\uc0c1\uc801\uc73c\ub85c \ud14c\uc774\ube14\uc774 \uc0dd\uc131\ub41c \uac83\uc785\ub2c8\ub2e4. <\/font><\/span><\/p>\n

<\/span><\/p>\n


<\/p>\n

\ud30c\uc774\uc36c\uc5d0\uc11c MySQL\uc744 \uc0ac\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294 \ubaa8\ub4c8\uc744 \uc124\uce58\ud574\uc57c\ud558\ub294\ub370 \ub2e4\uc74c\uacfc \uac19\uc774 \uc124\uce58\ud558\uba74 \ub429\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

http:\/\/www.lfd.uci.edu\/~gohlke\/pythonlibs\/#mysql-python<\/font><\/span><\/a><\/p>\n

\uc0ac\uc774\ud2b8\uc5d0\uc11c <\/font><\/span><\/p>\n

<\/span><\/p>\n

\uc911\uac04 CP\uc774\ud6c4\ub294 \ud30c\uc774\uc36c \ubc84\uc804\uc774\uba70 win32, amd64\ub294 32\ube44\ud2b8 64\ube44\ud2b8 \uad6c\ubd84\uc785\ub2c8\ub2e4. \ubcf8\uc778\uc774 \uc124\uce58\ud55c \ud30c\uc774\uc36c \ubc84\uc804\uc5d0 \ub530\ub77c \uc124\uce58\ud558\uba74 \ub429\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

<\/span><\/p>\n


<\/p>\n

\uc124\uce58\ubc29\ubc95\uc740 \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\uc740\ud6c4\uc5d0 \ud574\ub2f9\ud3f4\ub354\uc5d0\uc11c \uc704\uc640\uac19\uc774 pip\ub85c \uc778\uc2a4\ud1a8\ud558\uba74 \ub429\ub2c8\ub2e4.<\/font><\/span><\/p>\n


<\/p>\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc815\uc0c1\uc801\uc73c\ub85c \uc791\ub3d9\ud558\ub294\uc9c0 \ud655\uc778\ud574\ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. <\/font><\/span><\/p>\n

<\/span><\/p>\n

\uc704\uc758 \ucf54\ub4dc\ub97c \uc0b4\ud3b4\ubcf4\uba74 \uc124\uce58\ub41c MySQLdb \ubaa8\ub4c8\uc744 \ud1b5\ud574\uc11c mySQL\uc5d0 \uc811\uc18d\ud558\uace0 \uc811\uc18d\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ubc84\uc804\uc744 \uac00\uc838\uc640\uc11c \ucd9c\ub825\ud558\ub294 \ud504\ub85c\uadf8\ub7a8\uc785\ub2c8\ub2e4. <\/font><\/span><\/p>\n

\uc5ec\uae30\uc5d0\uc11c \uc544\ub798\uc640 \uac19\uc774 \ub098\uc654\ub2e4\uba74 \uc815\uc0c1\uc801\uc73c\ub85c \ubaa8\ub4c8\uc774 \uc124\uce58\ub418\uc5b4 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud504\ub85c\uadf8\ub7a8\uc744 \ud560 \uc900\ube44\uac00 \ub418\uc5c8\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

<\/span><\/p>\n



<\/p>\n

13.3.1 JSON\uc744 \uc774\uc6a9\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc811\uc18d<\/font><\/font><\/span><\/h3>\n


<\/p>\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc811\uc18d\ud560\ub54c \uc704\uc640\uac19\uc774 connect\ud568\uc218\uc5d0 \uc9c1\uc811\uc368\uc8fc\ub294 \ubc29\ubc95\ub3c4 \uc788\uc9c0\ub9cc \uc774\ub807\uac8c \ub418\uba74 Database \ub97c \ubcc0\uacbd\ud558\uac70\ub098 \uc704\uce58\ub97c \ubcc0\uacbd\ud558\uac70\ub098 \ub610\ub294 \uc0ac\uc6a9\uc790\ub97c \ubcc0\uacbd\ud558\ub824\uace0 \ud560\ub54c \ubd88\ud3b8\ud560\uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7f0\uacbd\uc6b0 \ubcc4\ub3c4\uc758 \ud30c\uc77c\uc5d0 \uc774\ub7ec\ud55c \uc815\ubcf4\ub97c \ub123\uc5b4\uc11c \ud574\ub2f9 \ud30c\uc77c\uc744 \ubcc0\uacbd\ud558\uba74 \uc811\uc18d\uc815\ubcf4\ub3c4 \ubcc0\uacbd\ub418\ub3c4\ub85d \ud558\ub294\uac83\uc774 \ubc29\ubc95\ub860 \uc801\uc73c\ub85c \uc88b\uc744\uac83\uc785\ub2c8\ub2e4. <\/font><\/span><\/p>\n



<\/p>\n

<\/span><\/p>\n

\uc704\uc640 \uac19\uc774 database.json\uc774\ub77c\ub294 \ud30c\uc77c\uc744 \ub9cc\ub4e4\uace0 \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \uc774 \ud30c\uc77c\uc744 \ucc38\uace0\ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc811\uc18d\uc744 \ud558\ub294\uac83\uc785\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

<\/span><\/p>\n


<\/p>\n

\uc704\uc640\uac19\uc774 \uc18c\uc2a4\ub97c \ubcc0\uacbd\ud558\uc5ec \uc2e4\ud589\ud558\uba74 <\/font><\/span><\/p>\n


<\/p>\n

<\/span><\/p>\n

\uc704\uc640\uac19\uc774 \uc811\uc18d\uc5d0 \uc131\uacf5\ud558\ub294\uac83\uc744 \ud655\uc778\ud560\uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n","protected":false},"excerpt":{"rendered":"

C\uae09 \uac1c\ubc1c\uc790\uc640 \ud568\uaed8\ud558\ub294 \ud30c\uc774\uc36c 13.3 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud14c\uc774\ube14 \uc0dd\uc131\ud558\uae30 \uc6b0\uc120 \uc5f0\uc2b5\uc744 \uc704\ud574\uc11c \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud574 \ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. \ud68c\uc6d0 \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uc5b4\uc11c \uc785\ub825, \uc218\uc815, \uc0ad\uc81c\ub97c \ud558\ub294\ubd80\ubd84\uc744 \ud504\ub85c\uadf8\ub798\ubc0d \ud574\ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uae30\ubcf8\uc801\uc73c\ub85c \uad00\ub9ac\uac00 \ud544\uc694\ud55c \uc815\ubcf4\ub97c \ub123\uc5b4\uc11c \uad00\ub9ac\ud558\ub294 \uc77c\uc744 \ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uc6b0\ub9ac\uac00 \ud68c\uc6d0\ud14c\uc774\ube14\uc744 \uc5b4\ub5bb\uac8c \ub9cc\ub4e4\uace0 \uc5b4\ub5bb\uac8c \ud14c\uc774\ube14 \uc815\uc758\ub97c \ud558\ub294\uc9c0 \uc54c\uc544\ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. \uc5ec\uae30\uc5d0\uc11c \ub098\uc624\ub294 \ubd80\ubd84\uc740 \ub300\ub2e8\ud788 \ubd80\ubd84\uc801\uc774\uae30 \ub54c\ubb38\uc5d0 \uc2e4\uc81c \ud504\ub85c\uadf8\ub7a8\uac1c\ubc1c\uc5d0\uc11c \uc870\uae08 \ub2e4\ub974\uac8c … <\/p>\n

\ub354 \ubcf4\uae30 “13. \ub370\uc774\ud130\ubca0\uc774\uc2a4 13.3 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud14c\uc774\ube14 \uc0dd\uc131\ud558\uae30”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[5836],"tags":[16211,5291,24395,5625],"class_list":["post-20484","post","type-post","status-publish","format-standard","hentry","category-5836","tag-python","tag-5291","tag-24395","tag-5625","entry"],"_links":{"self":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts\/20484","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=20484"}],"version-history":[{"count":1,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts\/20484\/revisions"}],"predecessor-version":[{"id":20485,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts\/20484\/revisions\/20485"}],"wp:attachment":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=20484"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=20484"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=20484"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}