{"id":4782,"date":"2022-12-12T20:26:23","date_gmt":"2022-12-12T14:56:23","guid":{"rendered":"https:\/\/neonpolice.com\/?p=4782"},"modified":"2024-05-06T12:29:45","modified_gmt":"2024-05-06T06:59:45","slug":"sql-cheat-sheet","status":"publish","type":"post","link":"https:\/\/neonpolice.com\/kr\/sql-cheat-sheet\/","title":{"rendered":"\ub370\uc774\ud130 \ubd84\uc11d\uc744 \uc704\ud55c Datacamp\uc758 SQL \uce58\ud2b8 \uc2dc\ud2b8"},"content":{"rendered":"<p>\ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud1b5\uc2e0\uc740 SQL(Structured Query Language)\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc774\ub8e8\uc5b4\uc9d1\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0ac\uc6a9\ud558\uba74 \ub370\uc774\ud130\ub97c \uc800\uc7a5, \uac80\uc0c9 \ubc0f \uc870\uc791\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. SQL\uc740 Oracle, Microsoft SQL Server, PostgreSQL, MySQL\uc744 \ud3ec\ud568\ud55c \uac70\uc758 \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/p>\n<p>SQL \uce58\ud2b8 \uc2dc\ud2b8\ub294 \uae30\ubcf8 SQL \uba85\ub839\uc5d0 \ub300\ud55c \ub3c4\uc6c0\uc774 \ud544\uc694\ud55c \ubaa8\ub4e0 \uc0ac\ub78c\uc744 \uc704\ud55c \ube60\ub978 \ucc38\uc870 \uac00\uc774\ub4dc\uc785\ub2c8\ub2e4. \uc5ec\uae30\uc5d0\ub294 SELECT, INSERT, UPDATE, DELETE, CREATE\uc640 \uac19\uc740 \ub2e4\uc591\ud55c \uc720\ud615\uc758 \uba85\ub839\uc5d0 \ub300\ud55c \ubd84\uc11d\uc774 \ud3ec\ud568\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \ub610\ud55c \uc77c\ubc18\uc801\uc73c\ub85c \uc0ac\uc6a9\ub418\ub294 \ub370\uc774\ud130 \uc720\ud615\uacfc \uc5f0\uc0b0\uc790 \ubaa9\ub85d\uacfc \ub2e4\uc591\ud55c \uc720\ud615\uc758 \uc870\uc778 \ubc0f \uc808\uc5d0 \ub300\ud55c \uac1c\uc694\ub3c4 \ud3ec\ud568\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ub370\uc774\ud130\ub294 SELECT \uba85\ub839\uc744 \uc0ac\uc6a9\ud558\uc5ec \uac80\uc0c9\ud569\ub2c8\ub2e4. SELECT \ub4a4\uc5d0 \uc5f4 \uc774\ub984 \ubaa9\ub85d\uc774 \uc624\uac70\ub098, *\ub97c \uc0ac\uc6a9\ud558\uc5ec \ubaa8\ub4e0 \uc5f4\uc744 \uc120\ud0dd\ud558\ub294 \ud615\uc2dd\uc785\ub2c8\ub2e4. \ub610\ud55c WHERE \uc808\uc744 \ud3ec\ud568\ud558\uc5ec \ud2b9\uc815 \uae30\uc900\uacfc \uc77c\uce58\ud558\ub294 \ud589\uc73c\ub85c\ub9cc \uacb0\uacfc\ub97c \uc81c\ud55c\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<ul>\n<li>INSERT\ub294 \ud14c\uc774\ube14\uc5d0 \uc0c8 \ud589\uc744 \ucd94\uac00\ud569\ub2c8\ub2e4. INSERT INTO \ub2e4\uc74c\uc5d0 \ud14c\uc774\ube14 \uc774\ub984\uc774 \uc624\uace0, \uadf8 \ub2e4\uc74c\uc5d0 \uac12 \ubaa9\ub85d\uc774 \uc624\ub294 \ud615\uc2dd\uc744 \ucde8\ud569\ub2c8\ub2e4.<\/li>\n<li>UPDATE \uba85\ub839\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130\ub97c \uc218\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. UPDATE \ub4a4\uc5d0 \ud14c\uc774\ube14 \uc774\ub984\uc774 \uc624\uace0, \uadf8 \ub4a4\uc5d0 \uc5f4 \uc774\ub984\uacfc \uc0c8 \uac12 \ubaa9\ub85d\uc774 \ud3ec\ud568\ub41c SET \uc808\uc774 \uc624\ub294 \ud615\uc2dd\uc744 \ucde8\ud569\ub2c8\ub2e4.<\/li>\n<li>\ud14c\uc774\ube14 \ud589\uc740 DELETE \uba85\ub839\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc0ad\uc81c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. DELETE FROM \ub4a4\uc5d0 \ud14c\uc774\ube14 \uc774\ub984\uc744 \uc4f0\uace0, WHERE \uc808\uc744 \uc368\uc11c \ud2b9\uc815 \uae30\uc900\uc5d0 \ub9de\ub294 \ud589\ub9cc \uacb0\uacfc\ub85c \uc81c\ud55c\ud558\ub294 \ud615\uc2dd\uc744 \ucde8\ud569\ub2c8\ub2e4.<\/li>\n<li>CREATE \uba85\ub839\uc740 \uc0c8 \ud14c\uc774\ube14\uc744 \ub9cc\ub4dc\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. CREATE TABLE \ud615\uc2dd\uc774\uba70, \uadf8 \ub4a4\uc5d0 \ud14c\uc774\ube14 \uc774\ub984\uc774 \uc624\uace0, \uadf8 \ub2e4\uc74c\uc5d0 \uc5f4\uacfc \ud574\ub2f9 \ub370\uc774\ud130 \uc720\ud615 \ubaa9\ub85d\uc774 \uc635\ub2c8\ub2e4.<\/li>\n<\/ul>\n<p>SQL \uce58\ud2b8 \uc2dc\ud2b8\uc5d0\ub294 \uc77c\ubc18\uc801\uc73c\ub85c \uc0ac\uc6a9\ub418\ub294 \ub370\uc774\ud130 \uc720\ud615\uacfc \uc5f0\uc0b0\uc790 \ubaa9\ub85d\ub3c4 \ud3ec\ud568\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130 \uc720\ud615\uc5d0\ub294 \uc815\uc218, \ubb38\uc790\uc5f4, \ub0a0\uc9dc \ubc0f \ubd80\uc6b8\uc774 \ud3ec\ud568\ub429\ub2c8\ub2e4. \uc5f0\uc0b0\uc790\uc5d0\ub294 \uac19\uc74c, \ubcf4\ub2e4 \ud07c, \ubcf4\ub2e4 \uc791\uc74c \ubc0f LIKE\uac00 \ud3ec\ud568\ub429\ub2c8\ub2e4.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_78 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\ubaa9\ucc28<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"\ubaa9\ucc28 \ud1a0\uae00\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">\ube44\ub140\uc7a5<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/neonpolice.com\/kr\/sql-cheat-sheet\/#An_SQL_cheat_sheet_on_Datacamp\" >Datacamp\uc758 SQL \uce58\ud2b8 \uc2dc\ud2b8<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/neonpolice.com\/kr\/sql-cheat-sheet\/#1_The_SELECT_command\" >1. SELECT \uba85\ub839<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/neonpolice.com\/kr\/sql-cheat-sheet\/#2_The_INSERT_command\" >2. INSERT \uba85\ub839<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/neonpolice.com\/kr\/sql-cheat-sheet\/#3_The_UPDATE_command\" >3. UPDATE \uba85\ub839<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/neonpolice.com\/kr\/sql-cheat-sheet\/#4_The_DELETE_command\" >4. DELETE \uba85\ub839<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/neonpolice.com\/kr\/sql-cheat-sheet\/#5_The_CREATE_command\" >5. CREATE \uba85\ub839<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/neonpolice.com\/kr\/sql-cheat-sheet\/#Conclusion\" >\uacb0\ub860<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/neonpolice.com\/kr\/sql-cheat-sheet\/#FAQs\" >\uc790\uc8fc \ubb3b\ub294 \uc9c8\ubb38<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"An_SQL_cheat_sheet_on_Datacamp\"><\/span>Datacamp\uc758 SQL \uce58\ud2b8 \uc2dc\ud2b8<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>SQL \uce58\ud2b8 \uc2dc\ud2b8\ub294 <a href=\"https:\/\/bit.ly\/3H50S2E\" target=\"_blank\" rel=\"nofollow noopener sponsored\">\ube60\ub978 \ucc38\uc870 \uac00\uc774\ub4dc<\/a> \uae30\ubcf8 SQL\uc5d0 \ub300\ud55c \ub3c4\uc6c0\uc774 \ud544\uc694\ud55c \ubaa8\ub4e0 \uc0ac\ub78c\uc744 \uc704\ud574. SQL \uba85\ub839\uc5d0 \ub300\ud55c \uc790\uc138\ud55c \uc124\uba85\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"1_The_SELECT_command\"><\/span>1. SELECT \uba85\ub839<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div id=\"attachment_4806\" style=\"width: 910px\" class=\"wp-caption alignnone\"><img decoding=\"async\" aria-describedby=\"caption-attachment-4806\" class=\"size-full wp-image-4806\" src=\"https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/12\/The-SELECT-command.webp\" alt=\"SELECT command is used to retrieve data\" width=\"900\" height=\"500\" srcset=\"https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/12\/The-SELECT-command.webp 900w, https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/12\/The-SELECT-command-300x167.webp 300w, https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/12\/The-SELECT-command-768x427.webp 768w, https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/12\/The-SELECT-command-585x325.webp 585w, https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/12\/The-SELECT-command-150x83.webp 150w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/><p id=\"caption-attachment-4806\" class=\"wp-caption-text\">SELECT \uba85\ub839 | Neonpolice<\/p><\/div>\n<p>SQL SELECT \uba85\ub839\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud14c\uc774\ube14\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac80\uc0c9\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. \uac00\uc7a5 \uc77c\ubc18\uc801\uc73c\ub85c \uc0ac\uc6a9\ub418\ub294 SQL \uba85\ub839 \uc911 \ud558\ub098\uc774\uba70<a href=\"https:\/\/bit.ly\/3H50S2E\" target=\"_blank\" rel=\"nofollow noopener sponsored\"> \ub2e8\uc77c \ud14c\uc774\ube14\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\ub294 \ub370 \uc0ac\uc6a9\ub428<\/a> \ub610\ub294 \uc5ec\ub7ec \ud14c\uc774\ube14. SELECT \uba85\ub839\uc744 \uc0ac\uc6a9\ud558\uba74 \uacb0\uacfc\uc5d0 \ud3ec\ud568\ud558\ub824\ub294 \uc5f4\uc744 \uc120\ud0dd\ud558\uace0, \uacb0\uacfc \uc9d1\ud569\uc744 \ud544\ud130\ub9c1\ud558\uae30 \uc704\ud55c \uc870\uac74\uc744 \uc9c0\uc815\ud558\uace0, \ud14c\uc774\ube14\uc744 \uc870\uc778\ud558\uace0, \uacb0\uacfc\ub97c \uadf8\ub8f9\ud654\ud558\ub294 \ub4f1\uc758 \uc791\uc5c5\uc744 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>SELECT \uba85\ub839\uc5d0\ub294 \ub2e4\uc74c\uc774 \uc788\uc2b5\ub2c8\ub2e4. <a href=\"https:\/\/bit.ly\/3H50S2E\" target=\"_blank\" rel=\"nofollow noopener sponsored\">sql \uad6c\ubb38 \uce58\ud2b8 \uc2dc\ud2b8<\/a>:<br \/>\nINTO(\ud14c\uc774\ube14) SELECT(\uc5f4) WHERE(\uc870\uac74) ORDER BY(\uc5f4).<\/p>\n<p>\ucd9c\ub825\uc5d0 \ud3ec\ud568\ud558\ub824\ub294 \uc5f4\uc740 \uc5b4\ub514\uc5d0 \uc788\uace0, [table]\uc740 \ub370\uc774\ud130\ub97c \uac80\uc0c9\ud574\uc57c \ud558\ub294 \ud14c\uc774\ube14\uc758 \uc774\ub984\uc774\uace0, [conditions]\ub294 \uacb0\uacfc \uc9d1\ud569\uc744 \uc81c\ud55c\ud558\ub294 \uc870\uac74\uc785\ub2c8\ub2e4. ORDER BY \uc808\uc740 \uc120\ud0dd \uc0ac\ud56d\uc774\uba70 \ud2b9\uc815 \uc21c\uc11c\ub85c \uacb0\uacfc\ub97c \uc815\ub82c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<hr \/>\n<p>\ub610\ud55c \uc77d\uc5b4\ubcf4\uc138\uc694: <a href=\"https:\/\/neonpolice.com\/kr\/power-bi-dashboard-tools\/\">\ub354 \ub098\uc740 \uc2dc\uac01\ud654\uc640 \ubd84\uc11d\uc744 \uc704\ud55c \ucd5c\uace0\uc758 Power BI \ub300\uc2dc\ubcf4\ub4dc \ub3c4\uad6c 5\uac00\uc9c0!\u00a0<\/a><\/p>\n<hr \/>\n<h3><span class=\"ez-toc-section\" id=\"2_The_INSERT_command\"><\/span>2. INSERT \uba85\ub839<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><iframe title=\"\ube14\ub85d\uc5d0 \ub300\ud55c \uc0bd\uc785 \uba85\ub839 \uc0ac\uc6a9\" width=\"1170\" height=\"658\" src=\"https:\/\/www.youtube.com\/embed\/1KMLLSFXHAw?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p>INSERT \uba85\ub839\uc740 <a href=\"https:\/\/bit.ly\/3H50S2E\" target=\"_blank\" rel=\"nofollow noopener sponsored\">\uad6c\uc870\ud654\ub41c \ucffc\ub9ac \uc5b8\uc5b4(SQL)<\/a> \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud14c\uc774\ube14\uc5d0 \uc0c8 \ub808\ucf54\ub4dc\ub97c \ucd94\uac00\ud558\ub294 \ub370 \uc0ac\uc6a9\ub418\ub294 \uba85\ub839\uc785\ub2c8\ub2e4. \uc774 \uba85\ub839\uc744 \uc0ac\uc6a9\ud558\uba74 \uc0ac\uc6a9\uc790\uac00 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud14c\uc774\ube14\uc5d0 \uc0c8 \ub370\uc774\ud130\ub97c \ucd94\uac00\ud558\uac70\ub098 \uae30\uc874 \ub370\uc774\ud130\ub97c \uc5c5\ub370\uc774\ud2b8\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ud14c\uc774\ube14 \uc774\ub984\uc740 &quot;INSERT INTO TABLE_NAME VALUES (column1, column2, \u2026, column)&quot; \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc5f4\uc5d0 \uc0bd\uc785\ub429\ub2c8\ub2e4. \ub2e4\uc74c \uc608\ub294 &quot;CUSTOMERS&quot; \ud14c\uc774\ube14\uc5d0 \uc0c8 \ub808\ucf54\ub4dc\ub97c \uc0bd\uc785\ud558\ub294 \uad6c\ubb38\uc744 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4.<\/p>\n<p>\uace0\uac1d\uc5d0\uac8c \uc0bd\uc785<\/p>\n<p>\uac12(43, &#039;John Doe&#039;, &#039;john@example.com&#039;, &#039;123 Any Street&#039;);<\/p>\n<p>\uc704\uc758 \ubb38\uc7a5\uc740 CUSTOMERS \ud14c\uc774\ube14\uc5d0 \uc0c8 \ub808\ucf54\ub4dc\ub97c \uc0bd\uc785\ud569\ub2c8\ub2e4. \uc5f4 \uc774\ub984 &quot;ID&quot;, &quot;NAME&quot;, &quot;EMAIL&quot; \ubc0f &quot;ADDRESS&quot;\ub294 \ub370\uc774\ud130\ub85c \ucc44\uc6cc\uc9c8 \uc5f4\ub85c \uc9c0\uc815\ub429\ub2c8\ub2e4. VALUES \uc808\uc740 \ub098\uc5f4\ub41c \uc21c\uc11c\ub300\ub85c \uac01 \uc5f4\uc5d0 \uc0bd\uc785\ub420 \ub370\uc774\ud130\ub97c \uc9c0\uc815\ud569\ub2c8\ub2e4.<\/p>\n<hr \/>\n<h3><span class=\"ez-toc-section\" id=\"3_The_UPDATE_command\"><\/span>3. UPDATE \uba85\ub839<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div id=\"attachment_4805\" style=\"width: 910px\" class=\"wp-caption alignnone\"><img decoding=\"async\" aria-describedby=\"caption-attachment-4805\" class=\"size-full wp-image-4805\" src=\"https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/12\/The-UPDATE-command.webp\" alt=\"SQL UPDATE is a command used to modify existing records\" width=\"900\" height=\"500\" srcset=\"https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/12\/The-UPDATE-command.webp 900w, https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/12\/The-UPDATE-command-300x167.webp 300w, https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/12\/The-UPDATE-command-768x427.webp 768w, https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/12\/The-UPDATE-command-585x325.webp 585w, https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/12\/The-UPDATE-command-150x83.webp 150w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/><p id=\"caption-attachment-4805\" class=\"wp-caption-text\">UPDATE \uba85\ub839 | Neonpolice<\/p><\/div>\n<p>SQL UPDATE\ub294 <a href=\"https:\/\/bit.ly\/3H50S2E\" target=\"_blank\" rel=\"nofollow noopener sponsored\">\uae30\uc874 \ub808\ucf54\ub4dc\ub97c \uc218\uc815\ud558\ub294 \ub370 \uc0ac\uc6a9\ub418\ub294 \uba85\ub839<\/a> SQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud14c\uc774\ube14\uc5d0\uc11c. \ud14c\uc774\ube14\uc758 \ud544\ub4dc \uac12\uc744 \ubcc0\uacbd\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. \ud14c\uc774\ube14\uc5d0 \uc0c8 \ub808\ucf54\ub4dc\ub97c \ucd94\uac00\ud558\ub294 \ub370\ub3c4 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/p>\n<p>SQL UPDATE \uba85\ub839\uc758 \uae30\ubcf8 \uad6c\ubb38\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ub2e4\uc74c \uba85\ub839\ubb38\uc740 table_name\uc744 \uc5c5\ub370\uc774\ud2b8\ud569\ub2c8\ub2e4: SET column1 = new_value1, column2 = new_value2, \u2026, AND condition;<\/p>\n<p>UPDATE \uba85\ub839\uc5d0\ub294 \ub450 \uac00\uc9c0 \ub9e4\uac1c\ubcc0\uc218\uac00 \ud544\uc694\ud569\ub2c8\ub2e4. \ud14c\uc774\ube14 \uc774\ub984\uacfc \uc218\uc815\ud560 \uc5f4 \ubc0f \uac12 \uc138\ud2b8\uc785\ub2c8\ub2e4. WHERE \uc808\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc5c5\ub370\uc774\ud2b8\ud574\uc57c \ud560 \uc815\ud655\ud55c \ub808\ucf54\ub4dc \uc138\ud2b8\ub97c \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<hr \/>\n<h3><span class=\"ez-toc-section\" id=\"4_The_DELETE_command\"><\/span>4. DELETE \uba85\ub839<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div id=\"attachment_4807\" style=\"width: 910px\" class=\"wp-caption alignnone\"><img decoding=\"async\" aria-describedby=\"caption-attachment-4807\" class=\"size-full wp-image-4807\" src=\"https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/12\/The-DELETE-command.webp\" alt=\" It can be used to delete a single row\" width=\"900\" height=\"500\" srcset=\"https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/12\/The-DELETE-command.webp 900w, https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/12\/The-DELETE-command-300x167.webp 300w, https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/12\/The-DELETE-command-768x427.webp 768w, https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/12\/The-DELETE-command-585x325.webp 585w, https:\/\/neonpolice.com\/wp-content\/uploads\/2022\/12\/The-DELETE-command-150x83.webp 150w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/><p id=\"caption-attachment-4807\" class=\"wp-caption-text\">DELETE \uba85\ub839 | Neonpolice<\/p><\/div>\n<p>DELETE \uba85\ub839\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud14c\uc774\ube14\uc5d0\uc11c \uae30\uc874 \ub808\ucf54\ub4dc\ub97c \uc0ad\uc81c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud14c\uc774\ube14\uc5d0\uc11c \ub2e8\uc77c \ud589, \uc5ec\ub7ec \ud589 \ub610\ub294 \ubaa8\ub4e0 \ud589\uc744 \uc0ad\uc81c\ud558\ub294 \ub370 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub2e8\uc77c \ud589\uc744 \uc0ad\uc81c\ud558\ub824\uba74 \uba85\ub839\uc5d0\uc11c \uc0ad\uc81c\ud560 \uc815\ud655\ud55c \ud589\uc744 \uc9c0\uc815\ud574\uc57c \ud569\ub2c8\ub2e4. \uc5ec\ub7ec \ud589\uc744 \uc0ad\uc81c\ud558\ub824\uba74 \uba85\ub839\uc5d0\uc11c \uc0ad\uc81c\ud560 \ud589\uc744 \uc120\ud0dd\ud558\uae30 \uc704\ud55c \uae30\uc900\uc744 \uc815\uc758\ud558\ub294 WHERE \uc808\uc744 \uc9c0\uc815\ud574\uc57c \ud569\ub2c8\ub2e4. <a href=\"https:\/\/bit.ly\/3H50S2E\" target=\"_blank\" rel=\"nofollow noopener sponsored\">\ud14c\uc774\ube14\uc758 \ubaa8\ub4e0 \ud589\uc744 \uc0ad\uc81c\ud558\ub824\uba74 \uba85\ub839\uc5d0\uc11c \uac04\ub2e8\ud788 ALL \ud0a4\uc6cc\ub4dc\ub97c \uc0ac\uc6a9\ud558\uba74 \ub429\ub2c8\ub2e4.<\/a><\/p>\n<p>DELETE \uba85\ub839\uc758 \uad6c\ubb38\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ud14c\uc774\ube14 \uc774\ub984\uc5d0\uc11c \uc0ad\uc81c<\/p>\n[WHERE \uc870\uac74]\n<p>DELETE \uba85\ub839\uc740 \ub2e4\ub978 \uba85\ub839\uacfc \ud568\uaed8 \uc0ac\uc6a9\ud558\uc5ec \ub2e8\uc77c \uba85\ub839\ubb38\uc73c\ub85c \uc5ec\ub7ec \ud14c\uc774\ube14\uc5d0\uc11c \ub808\ucf54\ub4dc\ub97c \uc0ad\uc81c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<hr \/>\n<h3><span class=\"ez-toc-section\" id=\"5_The_CREATE_command\"><\/span>5. CREATE \uba85\ub839<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><iframe title=\"\ud14d\uc2a4\ud2b8 \uba85\ub839 \uc0dd\uc131\" width=\"1170\" height=\"658\" src=\"https:\/\/www.youtube.com\/embed\/-seelALiAyU?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p>CREATE \uba85\ub839\uc740 \ub2e4\uc74c\uc744 \uc704\ud574 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<a href=\"https:\/\/bit.ly\/3H50S2E\" target=\"_blank\" rel=\"nofollow noopener sponsored\"> \uc0c8 \ub370\uc774\ud130\ubca0\uc774\uc2a4, \ud14c\uc774\ube14, \ubdf0, \ud504\ub85c\uc2dc\uc800, \uc778\ub371\uc2a4, \ud2b8\ub9ac\uac70 \ub610\ub294 \uc0ac\uc6a9\uc790 \uc815\uc758 \ub370\uc774\ud130 \uc720\ud615\uc744 \ub9cc\ub4ed\ub2c8\ub2e4.<\/a>. \uc774 \uba85\ub839\uc740 \ud14c\uc774\ube14\uc5d0 \uc5b4\ub5a4 \uc5f4\uacfc \ub370\uc774\ud130 \uc720\ud615\uc774 \uc788\ub294\uc9c0, \uadf8\ub9ac\uace0 \uc11c\ub85c \uc5b4\ub5bb\uac8c \uad00\ub828\ub418\uc5b4 \uc788\ub294\uc9c0\uc640 \uac19\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad6c\uc870\ub97c \uc9c0\uc815\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. \ub610\ud55c \ud14c\uc774\ube14 \uac04\uc758 \uad00\uacc4\ub97c \uc9c0\uc815\ud558\ub294 \ub370\uc5d0\ub3c4 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/p>\n<p>CREATE \uba85\ub839\uc758 \uad6c\ubb38\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<p>CREATE [\uac1d\uccb4 \uc720\ud615] [\uac1d\uccb4 \uc774\ub984] (<\/p>\n[\uc5f4 \uc774\ub984] [\ub370\uc774\ud130 \uc720\ud615],<\/p>\n[\uc5f4 \uc774\ub984] [\ub370\uc774\ud130 \uc720\ud615],<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span>\uacb0\ub860<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\uc804\ubc18\uc801\uc73c\ub85c, <a href=\"https:\/\/bit.ly\/3H50S2E\" target=\"_blank\" rel=\"nofollow noopener sponsored\">SQL\uc758 \uc911\uc694\uc131<\/a> \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub0b4\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uc800\uc7a5, \uad00\ub9ac \ubc0f \uac80\uc0c9\ud558\ub294 \ub2a5\ub825\uc5d0 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub294 \uace0\uac1d \uc815\ubcf4, \uc81c\ud488 \uc815\ubcf4 \ubc0f \uc7ac\ubb34 \ub370\uc774\ud130\uc640 \uac19\uc740 \ub300\ub7c9\uc758 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud574\uc57c \ud558\ub294 \uae30\uc5c5\uc5d0 \ud544\uc218\uc801\uc778 \ub3c4\uad6c\uc785\ub2c8\ub2e4. <a href=\"https:\/\/en.wikipedia.org\/wiki\/SQL\" target=\"_blank\" rel=\"noopener\">SQL\ub3c4<\/a> \uae30\uc5c5\uc774 \ud544\uc694\ud55c \ub370\uc774\ud130\uc5d0 \ube60\ub974\uac8c \uc561\uc138\uc2a4\ud558\uae30 \uc704\ud574 \ubcf5\uc7a1\ud55c \ucffc\ub9ac\ub97c \ub9cc\ub4e4 \uc218 \uc788\ub3c4\ub85d \ud569\ub2c8\ub2e4. MySQL \uce58\ud2b8\uc2dc\ud2b8\uc5d0 \ub300\ud55c \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 <a href=\"https:\/\/neonpolice.com\/kr\/\" target=\"_blank\" rel=\"noopener\">Neon Police \uacf5\uc2dd \uc6f9\uc0ac\uc774\ud2b8\ub97c \ubc29\ubb38\ud558\uc138\uc694<\/a>.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"FAQs\"><\/span>\uc790\uc8fc \ubb3b\ub294 \uc9c8\ubb38<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div class=\"su-accordion su-u-trim\"><div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus su-spoiler-closed\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>DataCamp\uc5d0\uc11c SQL \uce58\ud2b8\uc2dc\ud2b8\ub294 \uc5b4\ub514\uc5d0 \uc788\ub098\uc694?<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">SQL \uce58\ud2b8 \uc2dc\ud2b8\ub294 DataCamp \uc0ac\uc6a9\uc790\uac00 \ub370\uc774\ud130 \uacfc\ud559 \ubc0f \ud504\ub85c\uadf8\ub798\ubc0d \uc8fc\uc81c\uc5d0 \ub300\ud55c \ud575\uc2ec \uac1c\ub150, \ud568\uc218 \ubc0f \uad6c\ubb38\uc744 \ube60\ub974\uac8c \ucc38\uc870\ud560 \uc218 \uc788\ub294 \uc88b\uc740 \ubc29\ubc95\uc785\ub2c8\ub2e4. SQL \uce58\ud2b8 \uc2dc\ud2b8\ub294 R, Python, SQL, git \ub4f1\uc744 \ud3ec\ud568\ud55c DataCamp\uc758 \ub2e4\uc591\ud55c \uc8fc\uc81c\uc5d0 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. DataCamp SQL \uce58\ud2b8 \uc2dc\ud2b8\ub294 \uc27d\uac8c \uc561\uc138\uc2a4\ud560 \uc218 \uc788\ub3c4\ub85d \uc6f9\uc0ac\uc774\ud2b8 \ud648\ud398\uc774\uc9c0\uc5d0 \ud3b8\ub9ac\ud558\uac8c \uc704\uce58\ud574 \uc788\uc2b5\ub2c8\ub2e4. DataCamp \ud648\ud398\uc774\uc9c0\ub85c \uc774\ub3d9\ud558\uc5ec &quot;\uce58\ud2b8 \uc2dc\ud2b8&quot; \uc139\uc158\uc73c\ub85c \uc2a4\ud06c\ub864\ud558\uae30\ub9cc \ud558\uba74 \ub429\ub2c8\ub2e4. \uac70\uae30\uc5d0\uc11c SQL \uce58\ud2b8 \uc2dc\ud2b8\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ubaa8\ub4e0 \uc8fc\uc81c \ubaa9\ub85d\uc744 \ucc3e\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus su-spoiler-closed\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>DataCamp\ub294 SQL\uc744 \ubc30\uc6b0\uae30\uc5d0 \uc88b\uc740\uac00\uc694?<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\ub300\ub2f5\uc740 \ud655\uc2e4\ud788 &#039;\uc608&#039;\uc785\ub2c8\ub2e4! DataCamp\ub294 \ucd5c\uadfc \uba87 \ub144 \ub3d9\uc548 \uc810\uc810 \ub354 \uc778\uae30\ub97c \uc5bb\uace0 \uc788\ub294 \uc628\ub77c\uc778 \ud559\uc2b5 \ud50c\ub7ab\ud3fc\uc774\uba70, \uadf8\ub7f4 \ub9cc\ud55c \uc774\uc720\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uc9c1\uad00\uc801\uc774\uace0 \ub300\ud654\ud615 \uacfc\uc815\uc744 \ud1b5\ud574 SQL\uc758 \uae30\ubcf8\uacfc \uace0\uae09 \uac1c\ub150\uc744 \ubc30\uc6b0\ub294 \uc644\ubcbd\ud55c \ubc29\ubc95\uc785\ub2c8\ub2e4. DataCamp\ub294 SQL\uc5d0 \ub300\ud55c \uc2ec\uce35\uc801\uc778 \uc774\ud574\ub97c \ub3d5\ub3c4\ub85d \uc124\uacc4\ub41c \uc2e4\uc81c \uc0ac\ub840\uc640 \uc2e4\uc2b5 \ud504\ub85c\uc81d\ud2b8\uac00 \ud3ec\ud568\ub41c \ub300\ud654\ud615 \uacfc\uc815\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus su-spoiler-closed\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>DataCamp\uc5d0\uc11c SQL\uc740 \ubb34\ub8cc\uc778\uac00\uc694?<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">SQL \uc5b8\uc5b4\uc5d0 \ub300\ud55c \ubb34\ub8cc \uc561\uc138\uc2a4 \uc678\uc5d0\ub3c4 DataCamp\ub294 \uc77c\ub828\uc758 \uc720\ub8cc \uacfc\uc815\ub3c4 \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uacfc\uc815\uc740 \uc5b8\uc5b4\uc5d0 \ub300\ud55c \ubcf4\ub2e4 \uc2ec\uce35\uc801\uc778 \ub0b4\uc6a9\uc744 \uc81c\uacf5\ud558\uace0 \uc5b8\uc5b4\uc5d0 \ub300\ud55c \ubcf4\ub2e4 \ud3ec\uad04\uc801\uc778 \uc774\ud574\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uacfc\uc815\uc740 \uc5b8\uc5b4\uc5d0 \ub2a5\uc219\ud574\uc9c0\ub824\ub294 \uc0ac\ub78c\uc774\ub098 \uc5b8\uc5b4 \uc804\ubb38\uac00\uac00 \ub418\uace0\uc790 \ud558\ub294 \uc0ac\ub78c\uc5d0\uac8c \uc774\uc0c1\uc801\uc785\ub2c8\ub2e4.<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus su-spoiler-closed\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>SQL\uc758 \uae30\ubcf8\uc740 \ubb34\uc5c7\uc785\ub2c8\uae4c?<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">SQL\uc758 \uae30\ubcf8\uc740 \uc5b8\uc5b4\uc758 \uad6c\ubb38\uacfc \uad6c\uc870\ub97c \uc774\ud574\ud558\ub294 \uac83\uc744 \ud3ec\ud568\ud569\ub2c8\ub2e4. \uc5ec\uae30\uc5d0\ub294 \uc815\uc218, \ubb38\uc790\uc5f4, \ub0a0\uc9dc\uc640 \uac19\uc740 \ub2e4\uc591\ud55c \ub370\uc774\ud130 \uc720\ud615\uacfc \ub370\uc774\ud130\ub97c \uc870\uc791\ud558\ub294 \ub370 \uc0ac\uc6a9\ub418\ub294 \ub2e4\uc591\ud55c \uba85\ub839\uc774 \ud3ec\ud568\ub429\ub2c8\ub2e4. \ucffc\ub9ac\ub97c \uad6c\uc131\ud558\ub294 \ub370 \uc0ac\uc6a9\ub418\ub294 \ub2e4\uc591\ud55c \uc808\uc744 \uc774\ud574\ud558\ub294 \uac83\ub3c4 \uc911\uc694\ud569\ub2c8\ub2e4.<\/div><\/div><\/div>\n<script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [{\n    \"@type\": \"Question\",\n    \"name\": \"Where are SQL cheat sheets on DataCamp?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"SQL Cheat sheets are a great way for DataCamp users to quickly reference key concepts, functions, and syntax for data science and programming topics. SQL Cheat sheets are available for a variety of topics on DataCamp, including R, Python, SQL, git, and more. DataCamp SQL cheat sheets are conveniently located on the homepage of the website for easy access. Simply go to the DataCamp homepage and scroll down to the \\\"Cheat Sheets\\\" section. There, you will find a list of all the topics that have SQL cheat sheets available.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"Is DataCamp good for learning SQL?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"The answer is a resounding yes! DataCamp is an online learning platform that has become increasingly popular in recent years, and for good reason. With its intuitive and interactive courses, it is the perfect way to learn the basics and advanced concepts of SQL. DataCamp provides interactive courses with real-world examples and hands-on projects designed to help you gain a deep understanding of SQL.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"Is SQL free on DataCamp?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"In addition to free access to the SQL language, DataCamp also offers a series of paid courses. These courses offer more in-depth coverage of the language and provide a more comprehensive understanding of the language. These courses are ideal for those who are looking to become proficient in the language or for those who are looking to become an expert in the language.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"What are the basics of SQL?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"The basics of SQL involve understanding the syntax and structure of the language. This includes the various data types, such as integers, strings, and dates, as well as the different commands used to manipulate data. It is also important to understand the different clauses used to construct queries.\"\n    }\n  }]\n}\n<\/script><\/p>\n<p>&nbsp;<\/p>","protected":false},"excerpt":{"rendered":"<p>\ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud1b5\uc2e0\uc740 SQL(Structured Query Language)\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc774\ub8e8\uc5b4\uc9d1\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0ac\uc6a9\ud558\uba74 \ub370\uc774\ud130\ub97c \uc800\uc7a5, \uac80\uc0c9 \ubc0f \uc870\uc791\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. SQL\uc740 Oracle, Microsoft\ub97c \ud3ec\ud568\ud55c \uac70\uc758 \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/p>","protected":false},"author":2,"featured_media":6561,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[252,1016],"tags":[],"class_list":["post-4782","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology","category-datacamp"],"_links":{"self":[{"href":"https:\/\/neonpolice.com\/kr\/wp-json\/wp\/v2\/posts\/4782","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/neonpolice.com\/kr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/neonpolice.com\/kr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/neonpolice.com\/kr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/neonpolice.com\/kr\/wp-json\/wp\/v2\/comments?post=4782"}],"version-history":[{"count":0,"href":"https:\/\/neonpolice.com\/kr\/wp-json\/wp\/v2\/posts\/4782\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/neonpolice.com\/kr\/wp-json\/wp\/v2\/media\/6561"}],"wp:attachment":[{"href":"https:\/\/neonpolice.com\/kr\/wp-json\/wp\/v2\/media?parent=4782"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/neonpolice.com\/kr\/wp-json\/wp\/v2\/categories?post=4782"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/neonpolice.com\/kr\/wp-json\/wp\/v2\/tags?post=4782"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}