{"id":226,"date":"2022-08-13T16:24:41","date_gmt":"2022-08-13T07:24:41","guid":{"rendered":"https:\/\/www.spacek.xyz\/mle\/?p=226"},"modified":"2022-08-13T16:24:41","modified_gmt":"2022-08-13T07:24:41","slug":"pymysql-%eb%aa%a8%eb%93%88%ec%82%ac%ec%9a%a9%ec%8b%9c-%ec%bb%ac%eb%9f%bc%eb%aa%85%ec%9c%bc%eb%a1%9c-%ea%b0%92-%ec%a1%b0%ed%9a%8c%ed%95%98%eb%8a%94-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"https:\/\/www.spacek.xyz\/mle\/?p=226","title":{"rendered":"pymysql \ubaa8\ub4c8\uc0ac\uc6a9\uc2dc \uceec\ub7fc\uba85\uc73c\ub85c \uac12 \uc870\ud68c\ud558\ub294 \ubc29\ubc95"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\ud30c\uc774\uc120\uc5d0\uc11c pymysql\uc744 \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0 \uae30\ubcf8\uc774 \uceec\ub7fc \uc778\ub371\uc2a4\uc5d0 \uc758\ud55c \ubc30\uc5f4\ub85c \uac12\uc774 \ub9ac\ud134\ub41c\ub2e4. \ub9cc\uc57d \uceec\ub7fc\uba85\uc73c\ub85c \uac12\uc744 \uc5bb\uace0 \uc2f6\ub2e4\uba74 \ub9ac\ub358\uac12\uc774 \ubc30\uc5f4\uc774 \uc544\ub2cc \ud574\uc26c\ub9f5\uc73c\ub85c \ub9ac\ud134\ub418\uac8c \ud574\uc57c \ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uac04\ub2e8\ud558\uac8c \uc544\ub798\uc640 \uac19\uc774 connect \ub97c \uc694\uccad\ud560 \ub54c &#8216;cursorclass=pymysql.cursors.DictCursor&#8217; \ub97c \ucd94\uac00\ud558\uba74 \ub41c\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>conn = pymysql.connect(host=hostname, user=username, passwd=password, db=database, port=port, use_unicode=True, charset='utf8', cursorclass=pymysql.cursors.DictCursor)\nmycursor = conn.cursor()\n\nmycursor.execute(\"SELECT * FROM tablename WHERE 1 LIMIT 1;\")\nresult = mycursor.fetchone()\ncolval = result&#91;\"colname\"]<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\ud30c\uc774\uc120\uc5d0\uc11c pymysql\uc744 \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0 \uae30\ubcf8\uc774 \uceec\ub7fc \uc778\ub371\uc2a4\uc5d0 \uc758\ud55c \ubc30\uc5f4\ub85c \uac12\uc774 \ub9ac\ud134\ub41c\ub2e4. \ub9cc\uc57d \uceec\ub7fc\uba85\uc73c\ub85c \uac12\uc744 \uc5bb\uace0 \uc2f6\ub2e4\uba74 \ub9ac\ub358\uac12\uc774 \ubc30\uc5f4\uc774 \uc544\ub2cc \ud574\uc26c\ub9f5\uc73c\ub85c \ub9ac\ud134\ub418\uac8c \ud574\uc57c \ud55c\ub2e4. \uac04\ub2e8\ud558\uac8c \uc544\ub798\uc640 \uac19\uc774 connect \ub97c \uc694\uccad\ud560 \ub54c &#8216;cursorclass=pymysql.cursors.DictCursor&#8217; \ub97c \ucd94\uac00\ud558\uba74 \ub41c\ub2e4.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[59],"tags":[60,38],"class_list":["post-226","post","type-post","status-publish","format-standard","hentry","category-python","tag-pymysql","tag-python"],"views":387,"_links":{"self":[{"href":"https:\/\/www.spacek.xyz\/mle\/index.php?rest_route=\/wp\/v2\/posts\/226","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.spacek.xyz\/mle\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.spacek.xyz\/mle\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.spacek.xyz\/mle\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.spacek.xyz\/mle\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=226"}],"version-history":[{"count":1,"href":"https:\/\/www.spacek.xyz\/mle\/index.php?rest_route=\/wp\/v2\/posts\/226\/revisions"}],"predecessor-version":[{"id":227,"href":"https:\/\/www.spacek.xyz\/mle\/index.php?rest_route=\/wp\/v2\/posts\/226\/revisions\/227"}],"wp:attachment":[{"href":"https:\/\/www.spacek.xyz\/mle\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=226"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.spacek.xyz\/mle\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=226"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.spacek.xyz\/mle\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=226"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}