{"id":7301,"date":"2024-10-17T01:39:30","date_gmt":"2024-10-17T01:39:30","guid":{"rendered":"https:\/\/pohang.eduwp.kr\/?p=7301"},"modified":"2026-04-20T04:31:03","modified_gmt":"2026-04-20T04:31:03","slug":"mysql-%ec%8b%9c%ed%97%98%ec%9e%90%eb%a3%8c","status":"publish","type":"post","link":"https:\/\/pohang.eduwp.kr\/?p=7301","title":{"rendered":"mysql \uc911\uac04\uace0\uc0ac 2\ubc88 \uc2dc\ud5d8\uc790\ub8cc"},"content":{"rendered":"<p>\uc601\ud6542024\ub144 1\uc6d4,2\uc6d4,3\uc6d4 \ub370\uc774\ud130<\/p>\n<p>\uc544\ub798\ud30c\uc77c\uc740 3\uac1c\uc758 csv\ubb38\uc11c\uac00 \uc555\ucd95\ub418\uc5b4 \uc788\uc73c\ub2c8 \uc555\ucd95\uc744 \ud480\uc5b4\uc11c \uac01\uac01 \uc0ac\uc6a9\ubc14\ub78d\ub2c8\ub2e4.<\/p>\n<p>\ud544\ub4dc \uc774\ub984\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. \uc2e4\uc2b5\uc2dc\uac04\ub54c \uc0ac\uc6a9\ud55c \ud544\ub4dc\uc5d0\uc11c \uba87\uac1c \ucd95\uc18c\ub41c \ud544\ub4dc\uc785\ub2c8\ub2e4.<\/p>\n<hr \/>\n<p>\ud544\ub4dc\uc124\uba85 \uc548\ub0b4 \uc8fc\uc18c<\/p>\n<p><a href=\"https:\/\/www.bigdata-culture.kr\/bigdata\/user\/data_market\/detail.do?id=9d00dd80-4a54-11eb-af9a-4b03f0a582d6\" target=\"_blank\" rel=\"noopener\">https:\/\/www.bigdata-culture.kr\/bigdata\/user\/data_market\/detail.do?id=9d00dd80-4a54-11eb-af9a-4b03f0a582d6<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>NO<br \/>\nMOVIE_NM<br \/>\nDRCTR_NM<br \/>\nDISTB_CMPNY_NM<br \/>\nOPN_DE<br \/>\nMOVIE_TY_NM<br \/>\nNLTY_NM<br \/>\nTOT_SCRN_CO<br \/>\nSALES_PRICE<br \/>\nVIEWNG_NMPR_CO<br \/>\nSEOUL_SALES_PRICE<br \/>\nSEOUL_VIEWNG_NMPR_CO<br \/>\nGENRE_NM<br \/>\nGRAD_NM<br \/>\nMOVIE_SDIV_NM<\/p>\n<hr \/>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/pohang.eduwp.kr\/wp-content\/uploads\/2024\/10\/csv.zip\">utf \ubcc0\ud658\ub41c csv<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/pohang.eduwp.kr\/wp-content\/uploads\/2024\/10\/size_down.zip\">\uae30\ubcf8 csv<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>\ucc38\uc870<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">CREATE DATABASE movieDB; \r\nUSE movieDB; \r\n\r\nCREATE TABLE movie_info_01 (\r\n no DECIMAL(30,0) ,\r\n movie_nm VARCHAR(200),\r\n drctr_nm VARCHAR(200),\r\n makr_nm VARCHAR(200),\r\n INCME_CMPNY_NM VARCHAR(200),\r\n DISTB_CMPNY_NM VARCHAR (200),\r\n OPN_DE VARCHAR(8),\r\n MOVIE_TY_NM VARCHAR(200),\r\n MOVIE_STLE_NM VARCHAR(200),\r\n NLTY_NM VARCHAR (200),\r\n TOT_SCRN_CO DECIMAL (28,5),\r\n SALES_PRICE DECIMAL (28,5),\r\n VIEWNG_NMPR_CO DECIMAL (28,5),\r\n SEOUL_SALES_PRICE DECIMAL (28,5),\r\n SEOUL_VIEWNG_NMPR_CO DECIMAL (28,5),\r\n GENRE_NM VARCHAR(200),\r\n GRAD_NM VARCHAR(200),\r\n MOVIE_SDIV_NM VARCHAR(30) \r\n);<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc601\ud6542024\ub144 1\uc6d4,2\uc6d4,3\uc6d4 \ub370\uc774\ud130 \uc544\ub798\ud30c\uc77c\uc740 3\uac1c\uc758 csv\ubb38\uc11c\uac00 \uc555\ucd95\ub418\uc5b4 \uc788\uc73c\ub2c8 \uc555\ucd95\uc744 \ud480\uc5b4\uc11c \uac01\uac01 \uc0ac\uc6a9\ubc14\ub78d\ub2c8\ub2e4. \ud544\ub4dc \uc774\ub984\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. \uc2e4\uc2b5\uc2dc\uac04\ub54c \uc0ac\uc6a9\ud55c \ud544\ub4dc\uc5d0\uc11c \uba87\uac1c \ucd95\uc18c\ub41c \ud544\ub4dc\uc785\ub2c8\ub2e4. \ud544\ub4dc\uc124\uba85 \uc548\ub0b4 \uc8fc\uc18c https:\/\/www.bigdata-culture.kr\/bigdata\/user\/data_market\/detail.do?id=9d00dd80-4a54-11eb-af9a-4b03f0a582d6 &nbsp; NO MOVIE_NM DRCTR_NM&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[30],"tags":[],"class_list":["post-7301","post","type-post","status-publish","format-standard","category-mysql"],"_links":{"self":[{"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/posts\/7301","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7301"}],"version-history":[{"count":6,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/posts\/7301\/revisions"}],"predecessor-version":[{"id":7527,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/posts\/7301\/revisions\/7527"}],"wp:attachment":[{"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7301"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7301"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7301"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}