{"id":178,"date":"2025-03-17T02:07:20","date_gmt":"2025-03-17T02:07:20","guid":{"rendered":"http:\/\/www.soon7shop.kr\/wordpress\/?p=178"},"modified":"2025-03-17T02:08:39","modified_gmt":"2025-03-17T02:08:39","slug":"mysql%ec%97%90%ec%84%9c-%ed%8a%b9%ec%a0%95-%ed%85%8c%ec%9d%b4%eb%b8%94%ec%9d%98-%eb%82%b4%ec%9a%a9%ec%9d%84-%eb%b3%b4%eb%a0%a4%eb%a9%b4","status":"publish","type":"post","link":"https:\/\/www.soon7shop.kr\/wordpress\/?p=178","title":{"rendered":"MySQL\uc5d0\uc11c \ud2b9\uc815 \ud14c\uc774\ube14\uc758 \ub0b4\uc6a9\uc744 \ubcf4\ub824\uba74"},"content":{"rendered":"<p data-start=\"0\" data-end=\"39\">MySQL\uc5d0\uc11c \ud2b9\uc815 \ud14c\uc774\ube14\uc758 \ub0b4\uc6a9\uc744 \ubcf4\ub824\uba74 \ub2e4\uc74c \uc808\ucc28\ub97c \ub530\ub974\uba74 \ub429\ub2c8\ub2e4.<\/p>\n<ol data-start=\"41\" data-end=\"804\">\n<li data-start=\"41\" data-end=\"141\">\n<p data-start=\"44\" data-end=\"97\"><strong data-start=\"44\" data-end=\"58\">MySQL\uc5d0 \ub85c\uadf8\uc778<\/strong>: \ud130\ubbf8\ub110\uc5d0\uc11c MySQL\uc5d0 \ub85c\uadf8\uc778\ud558\ub824\uba74 \ub2e4\uc74c \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc138\uc694.<\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary\">\n<div class=\"flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between h-9 bg-token-sidebar-surface-primary dark:bg-token-main-surface-secondary select-none rounded-t-[5px]\">bash<\/div>\n<div class=\"sticky top-9\">\n<div class=\"absolute bottom-0 right-0 flex h-9 items-center pr-2\">\n<div class=\"flex items-center rounded bg-token-sidebar-surface-primary px-2 font-sans text-xs text-token-text-secondary dark:bg-token-main-surface-secondary\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre language-bash\">sudo mysql -u root -p<br \/>\n<\/code><\/div>\n<\/div>\n<\/li>\n<li data-start=\"143\" data-end=\"282\">\n<p data-start=\"146\" data-end=\"242\"><strong data-start=\"146\" data-end=\"159\">\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc120\ud0dd<\/strong>: \uba3c\uc800 \uc0ac\uc6a9\ud558\ub824\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc120\ud0dd\ud574\uc57c \ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, <code data-start=\"198\" data-end=\"213\">Homedaily_sum<\/code> \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc120\ud0dd\ud558\ub824\uba74 \ub2e4\uc74c \uba85\ub839\uc5b4\ub97c \uc785\ub825\ud569\ub2c8\ub2e4:<\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary\">\n<div class=\"flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between h-9 bg-token-sidebar-surface-primary dark:bg-token-main-surface-secondary select-none rounded-t-[5px]\">sql<\/div>\n<div class=\"sticky top-9\">\n<div class=\"absolute bottom-0 right-0 flex h-9 items-center pr-2\">\n<div class=\"flex items-center rounded bg-token-sidebar-surface-primary px-2 font-sans text-xs text-token-text-secondary dark:bg-token-main-surface-secondary\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre language-sql\">USE Homedaily_sum;<br \/>\n<\/code><\/div>\n<\/div>\n<\/li>\n<li data-start=\"284\" data-end=\"376\">\n<p data-start=\"287\" data-end=\"342\"><strong data-start=\"287\" data-end=\"300\">\ud14c\uc774\ube14 \ubaa9\ub85d \ubcf4\uae30<\/strong>: \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \ubaa8\ub4e0 \ud14c\uc774\ube14\uc744 \ud655\uc778\ud558\ub824\uba74 \ub2e4\uc74c \uba85\ub839\uc5b4\ub97c \uc785\ub825\ud569\ub2c8\ub2e4:<\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary\">\n<div class=\"flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between h-9 bg-token-sidebar-surface-primary dark:bg-token-main-surface-secondary select-none rounded-t-[5px]\">sql<\/div>\n<div class=\"sticky top-9\">\n<div class=\"absolute bottom-0 right-0 flex h-9 items-center pr-2\">\n<div class=\"flex items-center rounded bg-token-sidebar-surface-primary px-2 font-sans text-xs text-token-text-secondary dark:bg-token-main-surface-secondary\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre language-sql\"><span class=\"hljs-keyword\">SHOW<\/span> TABLES;<br \/>\n<\/code><\/div>\n<\/div>\n<\/li>\n<li data-start=\"378\" data-end=\"716\">\n<p data-start=\"381\" data-end=\"486\"><strong data-start=\"381\" data-end=\"398\">\ud2b9\uc815 \ud14c\uc774\ube14\uc758 \ub0b4\uc6a9 \ubcf4\uae30<\/strong>: \ud2b9\uc815 \ud14c\uc774\ube14\uc758 \ub0b4\uc6a9\uc744 \ubcf4\ub824\uba74 <code data-start=\"419\" data-end=\"427\">SELECT<\/code> \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, <code data-start=\"446\" data-end=\"456\" data-is-only-node=\"\">expenses<\/code>\ub77c\ub294 \ud14c\uc774\ube14\uc758 \ub0b4\uc6a9\uc744 \ubcf4\ub824\uba74 \ub2e4\uc74c \uba85\ub839\uc5b4\ub97c \uc785\ub825\ud569\ub2c8\ub2e4:<\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary\">\n<div class=\"flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between h-9 bg-token-sidebar-surface-primary dark:bg-token-main-surface-secondary select-none rounded-t-[5px]\">sql<\/div>\n<div class=\"sticky top-9\">\n<div class=\"absolute bottom-0 right-0 flex h-9 items-center pr-2\">\n<div class=\"flex items-center rounded bg-token-sidebar-surface-primary px-2 font-sans text-xs text-token-text-secondary dark:bg-token-main-surface-secondary\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre language-sql\"><span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-operator\">*<\/span> <span class=\"hljs-keyword\">FROM<\/span> expenses;<br \/>\n<\/code><\/div>\n<\/div>\n<p data-start=\"536\" data-end=\"660\">\uc774 \uba85\ub839\uc740 <code data-start=\"542\" data-end=\"552\">expenses<\/code> \ud14c\uc774\ube14\uc758 \ubaa8\ub4e0 \uc5f4\uc744 \ucd9c\ub825\ud569\ub2c8\ub2e4. \ub9cc\uc57d \ud2b9\uc815 \uceec\ub7fc\ub9cc \ubcf4\uace0 \uc2f6\ub2e4\uba74 <code data-start=\"588\" data-end=\"591\">*<\/code> \ub300\uc2e0 \uceec\ub7fc\uba85\uc744 \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, <code data-start=\"619\" data-end=\"625\">date<\/code>\uc640 <code data-start=\"627\" data-end=\"635\">amount<\/code> \uceec\ub7fc\ub9cc \ubcf4\uace0 \uc2f6\ub2e4\uba74 \ub2e4\uc74c\uacfc \uac19\uc774 \uc785\ub825\ud569\ub2c8\ub2e4:<\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary\">\n<div class=\"flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between h-9 bg-token-sidebar-surface-primary dark:bg-token-main-surface-secondary select-none rounded-t-[5px]\">sql<\/div>\n<div class=\"sticky top-9\">\n<div class=\"absolute bottom-0 right-0 flex h-9 items-center pr-2\">\n<div class=\"flex items-center rounded bg-token-sidebar-surface-primary px-2 font-sans text-xs text-token-text-secondary dark:bg-token-main-surface-secondary\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre language-sql\"><span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-type\">date<\/span>, amount <span class=\"hljs-keyword\">FROM<\/span> expenses;<br \/>\n<\/code><\/div>\n<\/div>\n<\/li>\n<li data-start=\"718\" data-end=\"804\">\n<p data-start=\"721\" data-end=\"777\"><strong data-start=\"721\" data-end=\"736\">MySQL\uc5d0\uc11c \ub098\uac00\uae30<\/strong>: \uc791\uc5c5\uc774 \ub05d\ub09c \ud6c4 MySQL\uc5d0\uc11c \ub098\uac00\ub824\uba74 \ub2e4\uc74c \uba85\ub839\uc5b4\ub97c \uc785\ub825\ud569\ub2c8\ub2e4:<\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary\">\n<div class=\"flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between h-9 bg-token-sidebar-surface-primary dark:bg-token-main-surface-secondary select-none rounded-t-[5px]\">sql<\/div>\n<div class=\"sticky top-9\">\n<div class=\"absolute bottom-0 right-0 flex h-9 items-center pr-2\">\n<div class=\"flex items-center rounded bg-token-sidebar-surface-primary px-2 font-sans text-xs text-token-text-secondary dark:bg-token-main-surface-secondary\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre language-sql\">exit;<br \/>\n<\/code><\/div>\n<\/div>\n<\/li>\n<\/ol>\n<p data-start=\"806\" data-end=\"845\" data-is-last-node=\"\" data-is-only-node=\"\">\uc774\ub807\uac8c \ud558\uba74 MySQL\uc5d0\uc11c \uc6d0\ud558\ub294 \ud14c\uc774\ube14\uc758 \ub0b4\uc6a9\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL\uc5d0\uc11c \ud2b9\uc815 \ud14c\uc774\ube14\uc758 \ub0b4\uc6a9\uc744 \ubcf4\ub824\uba74 \ub2e4\uc74c \uc808\ucc28\ub97c \ub530\ub974\uba74 \ub429\ub2c8\ub2e4. MySQL\uc5d0 \ub85c\uadf8\uc778: \ud130\ubbf8\ub110\uc5d0\uc11c MySQL\uc5d0 \ub85c\uadf8\uc778\ud558\ub824\uba74 \ub2e4\uc74c \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc138\uc694. bash sudo mysql -u root -p \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc120\ud0dd: \uba3c\uc800 \uc0ac\uc6a9\ud558\ub824\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc120\ud0dd\ud574\uc57c \ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, Homedaily_sum \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc120\ud0dd\ud558\ub824\uba74 \ub2e4\uc74c \uba85\ub839\uc5b4\ub97c \uc785\ub825\ud569\ub2c8\ub2e4: sql USE Homedaily_sum; \ud14c\uc774\ube14 \ubaa9\ub85d \ubcf4\uae30: \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \ubaa8\ub4e0 \ud14c\uc774\ube14\uc744 \ud655\uc778\ud558\ub824\uba74 \ub2e4\uc74c \uba85\ub839\uc5b4\ub97c \uc785\ub825\ud569\ub2c8\ub2e4: sql SHOW TABLES; \ud2b9\uc815 &hellip; <a href=\"https:\/\/www.soon7shop.kr\/wordpress\/?p=178\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;MySQL\uc5d0\uc11c \ud2b9\uc815 \ud14c\uc774\ube14\uc758 \ub0b4\uc6a9\uc744 \ubcf4\ub824\uba74&#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-178","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/178","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=178"}],"version-history":[{"count":2,"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/178\/revisions"}],"predecessor-version":[{"id":180,"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/178\/revisions\/180"}],"wp:attachment":[{"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=178"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=178"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=178"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}