{"id":1690,"date":"2024-02-01T21:17:21","date_gmt":"2024-02-01T12:17:21","guid":{"rendered":"https:\/\/dohokin.com\/?p=1690"},"modified":"2024-02-01T21:17:21","modified_gmt":"2024-02-01T12:17:21","slug":"sql-%ec%a0%95%eb%a6%ac","status":"publish","type":"post","link":"https:\/\/dohokin.com\/?p=1690","title":{"rendered":"sql \uc815\ub9ac"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/dohokin.com\/wp-content\/uploads\/2024\/02\/image-3.png\" alt=\"\" class=\"wp-image-1693\"\/><\/figure>\n\n\n\n<p>\ud14c\uc774\ube14 \uc870\uc778\uc5d0 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\ub294 \uba85\ub839\uc5b4\ub294 <strong>ALL JOIN<\/strong> \uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>SQL\uc5d0\uc11c \uc0ac\uc6a9\ub418\ub294 \uc8fc\uc694 \uc870\uc778 \uc720\ud615\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:<\/p>\n\n\n\n<ul>\n<li><strong>LEFT JOIN<\/strong> (\ub610\ub294 LEFT OUTER JOIN): \uc67c\ucabd \ud14c\uc774\ube14\uc758 \ubaa8\ub4e0 \ub808\ucf54\ub4dc\uc640 \uc624\ub978\ucabd \ud14c\uc774\ube14\uc5d0\uc11c \uc77c\uce58\ud558\ub294 \ub808\ucf54\ub4dc\ub97c \ud3ec\ud568\ud569\ub2c8\ub2e4. \uc77c\uce58\ud558\ub294 \ub808\ucf54\ub4dc\uac00 \uc5c6\ub294 \uacbd\uc6b0 \uc624\ub978\ucabd \ud14c\uc774\ube14\uc758 \uceec\ub7fc\uc740 NULL \uac12\uc744 \uac00\uc9d1\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>INNER JOIN<\/strong>: \ub450 \ud14c\uc774\ube14 \ubaa8\ub450\uc5d0\uc11c \uc77c\uce58\ud558\ub294 \ub808\ucf54\ub4dc\ub9cc\uc744 \ud3ec\ud568\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>FULL JOIN<\/strong> (\ub610\ub294 FULL OUTER JOIN): \ub450 \ud14c\uc774\ube14\uc758 \ubaa8\ub4e0 \ub808\ucf54\ub4dc\ub97c \ud3ec\ud568\ud558\uba70, \ud55c\ucabd \ud14c\uc774\ube14\uc5d0\ub9cc \uc874\uc7ac\ud558\ub294 \ub808\ucf54\ub4dc\uc758 \uacbd\uc6b0 \ub2e4\ub978 \ud14c\uc774\ube14\uc758 \uceec\ub7fc\uc740 NULL \uac12\uc744 \uac00\uc9d1\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n<p><strong>ALL JOIN<\/strong>\uc740 SQL \uc870\uc778 \uc720\ud615\uc73c\ub85c \uc874\uc7ac\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uba85\ub839\ubb38\uacfc \uc124\uba85\uc774 \ub9de\uc9c0 \uc54a\ub294 \uac83\uc740 <strong>\ub370\uc774\ud130 \uc870\ud68c &#8211; SELECT FROM<\/strong> \uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc815\ud655\ud55c \uba85\ub839\ubb38\uc740 <strong>SELECT<\/strong> \ub9cc\uc73c\ub85c \ucda9\ubd84\ud558\uba70, \ub370\uc774\ud130\ub97c \uc870\ud68c\ud560 \ub54c \uc0ac\uc6a9\ub418\ub294 SQL \uad6c\ubb38\uc740 <code>SELECT<\/code> \ub2e4\uc74c\uc5d0 \uc870\ud68c\ud558\ub824\ub294 \uceec\ub7fc \uc774\ub984\uc744 \uba85\uc2dc\ud558\uace0, <code>FROM<\/code> \ub2e4\uc74c\uc5d0 \ud574\ub2f9 \uceec\ub7fc\uc774 \uc18d\ud55c \ud14c\uc774\ube14 \uc774\ub984\uc744 \uba85\uc2dc\ud569\ub2c8\ub2e4. \ub530\ub77c\uc11c \uc815\ud655\ud55c \uba85\ub839\ubb38\uc740 <strong>SELECT \u2026 FROM \u2026<\/strong> \uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ub098\uba38\uc9c0 \uba85\ub839\ubb38\uacfc \uc124\uba85\uc740 \ubaa8\ub450 \uc815\ud655\ud569\ub2c8\ub2e4:<\/p>\n\n\n\n<ul>\n<li>\ub370\uc774\ud130 \uc5c5\ub370\uc774\ud2b8: <code>UPDATE ... SET ...<\/code><\/li>\n\n\n\n<li>\ub370\uc774\ud130 \uc81c\uac70: <code>DELETE FROM ...<\/code><\/li>\n\n\n\n<li>\ub370\uc774\ud130 \uc0dd\uc131: <code>CREATE TABLE ...<\/code><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"873\" src=\"https:\/\/dohokin.com\/wp-content\/uploads\/2024\/02\/image-2-1024x873.png\" alt=\"\" class=\"wp-image-1692\" srcset=\"https:\/\/dohokin.com\/wp-content\/uploads\/2024\/02\/image-2-1024x873.png 1024w, https:\/\/dohokin.com\/wp-content\/uploads\/2024\/02\/image-2-300x256.png 300w, https:\/\/dohokin.com\/wp-content\/uploads\/2024\/02\/image-2-768x655.png 768w, https:\/\/dohokin.com\/wp-content\/uploads\/2024\/02\/image-2.png 1467w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\ud14c\uc774\ube14\uc758 \ub370\uc774\ud130\ub9cc \uc0ad\uc81c\ud558\uba74\uc11c \ud14c\uc774\ube14 \uad6c\uc870\ub294 \uc720\uc9c0\ud558\uace0\uc790 \ud560 \ub54c \uc0ac\uc6a9\ud558\ub294 \ucffc\ub9ac\ub85c \uc62c\ubc14\ub978 \uac83\uc740 <strong>TRUNCATE TABLE user;<\/strong> \uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<ul>\n<li><strong>TRUNCATE TABLE user;<\/strong>: \uc774 \uba85\ub839\uc740 <code>user<\/code> \ud14c\uc774\ube14\uc758 \ubaa8\ub4e0 \ub370\uc774\ud130\ub97c \uc0ad\uc81c\ud558\uc9c0\ub9cc, \ud14c\uc774\ube14 \uc790\uccb4\uc640 \uadf8 \uad6c\uc870(\uc2a4\ud0a4\ub9c8)\ub294 \ubcf4\uc874\ud569\ub2c8\ub2e4. <code>TRUNCATE<\/code>\ub294 <code>DELETE<\/code> \uba85\ub839\ubcf4\ub2e4 \ub354 \ube60\ub974\uac8c \uc791\ub3d9\ud558\uba70, \uc790\ub3d9 \uc99d\uac00(AUTO_INCREMENT) \uc18d\uc131\uc774 \uc788\ub294 \uceec\ub7fc\uc758 \uce74\uc6b4\ud130\ub3c4 \ucd08\uae30\ud654\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n<p>\ub2e4\ub978 \uba85\ub839\uc5b4\ub4e4\uc5d0 \ub300\ud55c \uc124\uba85:<\/p>\n\n\n\n<ul>\n<li><strong>DROP TABLE user;<\/strong>: <code>user<\/code> \ud14c\uc774\ube14\uacfc \uadf8 \uc548\uc758 \ubaa8\ub4e0 \ub370\uc774\ud130\ub97c \uc644\uc804\ud788 \uc0ad\uc81c\ud569\ub2c8\ub2e4. \ud14c\uc774\ube14 \uc790\uccb4\uac00 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uc81c\uac70\ub429\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>UPDATE \ucffc\ub9ac\ubb38\uc5d0\uc11c <code>SET<\/code>\uc5d0 \ub4e4\uc5b4\uac00\ub294 \uac12\uc5d0 \ub300\ud55c \uc124\uba85\uc73c\ub85c \uc62c\ubc14\ub978 \uac83\uc740 &#8220;\ubcc0\uacbd\ud560 \uc18d\uc131\uba85\uacfc \ubcc0\uacbd\ud560 \ub370\uc774\ud130&#8221;<\/strong> \uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p><code>UPDATE<\/code> \ucffc\ub9ac\ubb38\uc758 <code>SET<\/code> \uc808\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud14c\uc774\ube14\uc758 \ud2b9\uc815 \ub808\ucf54\ub4dc\ub97c \uc218\uc815\ud560 \ub54c, \ubcc0\uacbd\ud560 \uceec\ub7fc(\uc18d\uc131\uba85)\uacfc \ud574\ub2f9 \uceec\ub7fc\uc5d0 \uc124\uc815\ud560 \uc0c8\ub85c\uc6b4 \uac12(\ub370\uc774\ud130)\uc744 \uc9c0\uc815\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc544\ub798\uc5d0\ub294 \ub2e4\uc591\ud55c SQL \ucffc\ub9ac \uc608\uc81c\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc774 \uc608\uc81c\ub4e4\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uc790\uc8fc \uc0ac\uc6a9\ub418\ub294 \uc791\uc5c5\ub4e4\uc744 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1. \ud14c\uc774\ube14 \uc0dd\uc131\ud558\uae30<\/h3>\n\n\n\n<p>\uc0ac\uc6a9\uc790 \uc815\ubcf4\ub97c \uc800\uc7a5\ud558\ub294 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\ub294 \uc608\uc81c\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#0F111A\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" data-code=\"CREATE TABLE Users (\n    UserID INT PRIMARY KEY AUTO_INCREMENT,\n    Username VARCHAR(50) NOT NULL,\n    Email VARCHAR(100) UNIQUE NOT NULL,\n    Password VARCHAR(50) NOT NULL,\n    RegistrationDate DATE NOT NULL\n);\" style=\"color:#babed8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki material-theme-ocean\" style=\"background-color: #0F111A\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F78C6C\">CREATE<\/span><span style=\"color: #BABED8\"> <\/span><span style=\"color: #F78C6C\">TABLE<\/span><span style=\"color: #BABED8\"> <\/span><span style=\"color: #82AAFF\">Users<\/span><span style=\"color: #BABED8\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #BABED8\">    UserID <\/span><span style=\"color: #C792EA\">INT<\/span><span style=\"color: #BABED8\"> <\/span><span style=\"color: #C792EA\">PRIMARY KEY<\/span><span style=\"color: #BABED8\"> AUTO_INCREMENT,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #BABED8\">    Username <\/span><span style=\"color: #C792EA\">VARCHAR<\/span><span style=\"color: #BABED8\">(<\/span><span style=\"color: #F78C6C\">50<\/span><span style=\"color: #BABED8\">) <\/span><span style=\"color: #F78C6C\">NOT NULL<\/span><span style=\"color: #BABED8\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #BABED8\">    Email <\/span><span style=\"color: #C792EA\">VARCHAR<\/span><span style=\"color: #BABED8\">(<\/span><span style=\"color: #F78C6C\">100<\/span><span style=\"color: #BABED8\">) <\/span><span style=\"color: #F78C6C\">UNIQUE<\/span><span style=\"color: #BABED8\"> <\/span><span style=\"color: #F78C6C\">NOT NULL<\/span><span style=\"color: #BABED8\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #BABED8\">    <\/span><span style=\"color: #F78C6C\">Password<\/span><span style=\"color: #BABED8\"> <\/span><span style=\"color: #C792EA\">VARCHAR<\/span><span style=\"color: #BABED8\">(<\/span><span style=\"color: #F78C6C\">50<\/span><span style=\"color: #BABED8\">) <\/span><span style=\"color: #F78C6C\">NOT NULL<\/span><span style=\"color: #BABED8\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #BABED8\">    RegistrationDate <\/span><span style=\"color: #C792EA\">DATE<\/span><span style=\"color: #BABED8\"> <\/span><span style=\"color: #F78C6C\">NOT NULL<\/span><\/span>\n<span class=\"line\"><span style=\"color: #BABED8\">);<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">2. \ub370\uc774\ud130 \uc0bd\uc785\ud558\uae30<\/h3>\n\n\n\n<p>\uc0dd\uc131\ub41c <code>Users<\/code> \ud14c\uc774\ube14\uc5d0 \uc0ac\uc6a9\uc790 \uc815\ubcf4\ub97c \uc0bd\uc785\ud558\ub294 \uc608\uc81c\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#0F111A\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" data-code=\"INSERT INTO Users (Username, Email, Password, RegistrationDate)\nVALUES ('john_doe', 'john.doe@example.com', 'password123', '2023-01-01');\" style=\"color:#babed8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki material-theme-ocean\" style=\"background-color: #0F111A\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F78C6C\">INSERT INTO<\/span><span style=\"color: #BABED8\"> Users (Username, Email, <\/span><span style=\"color: #F78C6C\">Password<\/span><span style=\"color: #BABED8\">, RegistrationDate)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F78C6C\">VALUES<\/span><span style=\"color: #BABED8\"> (<\/span><span style=\"color: #89DDFF\">&#39;<\/span><span style=\"color: #C3E88D\">john_doe<\/span><span style=\"color: #89DDFF\">&#39;<\/span><span style=\"color: #BABED8\">, <\/span><span style=\"color: #89DDFF\">&#39;<\/span><span style=\"color: #C3E88D\">john.doe@example.com<\/span><span style=\"color: #89DDFF\">&#39;<\/span><span style=\"color: #BABED8\">, <\/span><span style=\"color: #89DDFF\">&#39;<\/span><span style=\"color: #C3E88D\">password123<\/span><span style=\"color: #89DDFF\">&#39;<\/span><span style=\"color: #BABED8\">, <\/span><span style=\"color: #89DDFF\">&#39;<\/span><span style=\"color: #C3E88D\">2023-01-01<\/span><span style=\"color: #89DDFF\">&#39;<\/span><span style=\"color: #BABED8\">);<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">3. \ub370\uc774\ud130 \uc870\ud68c\ud558\uae30<\/h3>\n\n\n\n<p><code>Users<\/code> \ud14c\uc774\ube14\uc5d0\uc11c \ubaa8\ub4e0 \uc0ac\uc6a9\uc790 \uc815\ubcf4\ub97c \uc870\ud68c\ud558\ub294 \uc608\uc81c\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#0F111A\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" data-code=\"SELECT * FROM Users;\" style=\"color:#babed8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki material-theme-ocean\" style=\"background-color: #0F111A\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F78C6C\">SELECT<\/span><span style=\"color: #BABED8\"> <\/span><span style=\"color: #89DDFF\">*<\/span><span style=\"color: #BABED8\"> <\/span><span style=\"color: #F78C6C\">FROM<\/span><span style=\"color: #BABED8\"> Users;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">4. \ub370\uc774\ud130 \uc5c5\ub370\uc774\ud2b8\ud558\uae30<\/h3>\n\n\n\n<p>\ud2b9\uc815 \uc0ac\uc6a9\uc790\uc758 \uc774\uba54\uc77c \uc8fc\uc18c\ub97c \uc5c5\ub370\uc774\ud2b8\ud558\ub294 \uc608\uc81c\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#0F111A\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" data-code=\"UPDATE Users\nSET Email = 'new.email@example.com'\nWHERE UserID = 1;\" style=\"color:#babed8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki material-theme-ocean\" style=\"background-color: #0F111A\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F78C6C\">UPDATE<\/span><span style=\"color: #BABED8\"> Users<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F78C6C\">SET<\/span><span style=\"color: #BABED8\"> Email <\/span><span style=\"color: #89DDFF\">=<\/span><span style=\"color: #BABED8\"> <\/span><span style=\"color: #89DDFF\">&#39;<\/span><span style=\"color: #C3E88D\">new.email@example.com<\/span><span style=\"color: #89DDFF\">&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F78C6C\">WHERE<\/span><span style=\"color: #BABED8\"> UserID <\/span><span style=\"color: #89DDFF\">=<\/span><span style=\"color: #BABED8\"> <\/span><span style=\"color: #F78C6C\">1<\/span><span style=\"color: #BABED8\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">5. \ub370\uc774\ud130 \uc0ad\uc81c\ud558\uae30<\/h3>\n\n\n\n<p><code>Users<\/code> \ud14c\uc774\ube14\uc5d0\uc11c \ud2b9\uc815 \uc0ac\uc6a9\uc790\ub97c \uc0ad\uc81c\ud558\ub294 \uc608\uc81c\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#0F111A\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" data-code=\"DELETE FROM Users\nWHERE UserID = 1;\" style=\"color:#babed8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki material-theme-ocean\" style=\"background-color: #0F111A\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F78C6C\">DELETE<\/span><span style=\"color: #BABED8\"> <\/span><span style=\"color: #F78C6C\">FROM<\/span><span style=\"color: #BABED8\"> Users<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F78C6C\">WHERE<\/span><span style=\"color: #BABED8\"> UserID <\/span><span style=\"color: #89DDFF\">=<\/span><span style=\"color: #BABED8\"> <\/span><span style=\"color: #F78C6C\">1<\/span><span style=\"color: #BABED8\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">6. \uc870\uac74\uc5d0 \ub9de\ub294 \ub370\uc774\ud130 \uc870\ud68c\ud558\uae30<\/h3>\n\n\n\n<p><code>Users<\/code> \ud14c\uc774\ube14\uc5d0\uc11c \ud2b9\uc815 \uc870\uac74(\uc608: \ud2b9\uc815 \ub0a0\uc9dc \uc774\ud6c4\uc5d0 \ub4f1\ub85d\ub41c \uc0ac\uc6a9\uc790)\uc744 \ub9cc\uc871\ud558\ub294 \uc0ac\uc6a9\uc790 \uc815\ubcf4\ub97c \uc870\ud68c\ud558\ub294 \uc608\uc81c\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#0F111A\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" data-code=\"SELECT * FROM Users\nWHERE RegistrationDate &gt; '2023-01-01';\" style=\"color:#babed8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki material-theme-ocean\" style=\"background-color: #0F111A\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F78C6C\">SELECT<\/span><span style=\"color: #BABED8\"> <\/span><span style=\"color: #89DDFF\">*<\/span><span style=\"color: #BABED8\"> <\/span><span style=\"color: #F78C6C\">FROM<\/span><span style=\"color: #BABED8\"> Users<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F78C6C\">WHERE<\/span><span style=\"color: #BABED8\"> RegistrationDate <\/span><span style=\"color: #89DDFF\">&gt;<\/span><span style=\"color: #BABED8\"> <\/span><span style=\"color: #89DDFF\">&#39;<\/span><span style=\"color: #C3E88D\">2023-01-01<\/span><span style=\"color: #89DDFF\">&#39;<\/span><span style=\"color: #BABED8\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">7. JOIN\uc744 \uc0ac\uc6a9\ud558\uc5ec \ub450 \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130 \uacb0\ud569\ud558\uae30<\/h3>\n\n\n\n<p>\uc0ac\uc6a9\uc790\uc640 \uadf8\ub4e4\uc758 \uc8fc\ubb38 \uc815\ubcf4\uac00 \ub2f4\uae34 \ub450 \ud14c\uc774\ube14\uc744 \uc870\uc778\ud558\ub294 \uc608\uc81c\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#0F111A\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" data-code=\"SELECT Users.Username, Orders.OrderDate, Orders.Amount\nFROM Users\nJOIN Orders ON Users.UserID = Orders.UserID\nWHERE Users.UserID = 1;\" style=\"color:#babed8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki material-theme-ocean\" style=\"background-color: #0F111A\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F78C6C\">SELECT<\/span><span style=\"color: #BABED8\"> Users.Username, Orders.OrderDate, Orders.Amount<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F78C6C\">FROM<\/span><span style=\"color: #BABED8\"> Users<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F78C6C\">JOIN<\/span><span style=\"color: #BABED8\"> Orders <\/span><span style=\"color: #F78C6C\">ON<\/span><span style=\"color: #BABED8\"> Users.UserID <\/span><span style=\"color: #89DDFF\">=<\/span><span style=\"color: #BABED8\"> Orders.UserID<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F78C6C\">WHERE<\/span><span style=\"color: #BABED8\"> Users.UserID <\/span><span style=\"color: #89DDFF\">=<\/span><span style=\"color: #BABED8\"> <\/span><span style=\"color: #F78C6C\">1<\/span><span style=\"color: #BABED8\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>\uc774 \uc608\uc81c\ub4e4\uc740 SQL\uc744 \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uae30\ubcf8\uc801\uc778 CRUD(Create, Read, Update, Delete) \uc791\uc5c5\uc744 \uc218\ud589\ud558\ub294 \ubc29\ubc95\uc744 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2dc\uc2a4\ud15c\ub9c8\ub2e4 SQL \uad6c\ubb38\uc5d0 \uc57d\uac04\uc758 \ucc28\uc774\uac00 \uc788\uc744 \uc218 \uc788\uc73c\ubbc0\ub85c, \uc0ac\uc6a9\ud558\ub294 \uc2dc\uc2a4\ud15c\uc758 \ubb38\uc11c\ub97c \ucc38\uc870\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\ud14c\uc774\ube14 \uc870\uc778 \uc2dc \uad50\uc9d1\ud569\uacfc \ub3d9\uc77c\ud55c \uacb0\uacfc\ub97c \ub9cc\ub4dc\ub294 \uc870\uc778\uc740 <strong>INNER JOIN<\/strong> \uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<ul>\n<li><strong>INNER JOIN<\/strong>\uc740 \ub450 \ud14c\uc774\ube14\uc5d0\uc11c \ub9e4\uce6d\ub418\ub294 \ud589\ub9cc\uc744 \uacb0\uacfc\ub85c \ubc18\ud658\ud569\ub2c8\ub2e4. \uc774\ub294 \ub450 \ud14c\uc774\ube14\uc758 \uad50\uc9d1\ud569\uc5d0 \ud574\ub2f9\ud558\ub294 \ub370\uc774\ud130\ub97c \uc120\ud0dd\ud558\ub294 \uac83\uacfc \ub3d9\uc77c\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n<p>\uc544\ub798\uc5d0\ub294 <code>INNER JOIN<\/code>\uc744 \uc0ac\uc6a9\ud558\uc5ec \ub450 \ud14c\uc774\ube14 \uac04\uc758 \uad50\uc9d1\ud569\uc744 \uc870\ud68c\ud558\ub294 SQL \ucffc\ub9ac \uc608\uc81c\ub97c \uc81c\uacf5\ud558\uaca0\uc2b5\ub2c8\ub2e4. \uc774 \uc608\uc81c\uc5d0\uc11c\ub294 <code>Users<\/code> \ud14c\uc774\ube14\uacfc <code>Orders<\/code> \ud14c\uc774\ube14\uc744 \uc870\uc778\ud558\uc5ec, \uc8fc\ubb38 \uc815\ubcf4\uc640 \ud568\uaed8 \uc0ac\uc6a9\uc790 \uc815\ubcf4\ub97c \uc870\ud68c\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ud14c\uc774\ube14 \uad6c\uc870 \uc608\uc81c<\/h3>\n\n\n\n<ul>\n<li><code>Users<\/code> \ud14c\uc774\ube14: \uc0ac\uc6a9\uc790 \uc815\ubcf4\ub97c \uc800\uc7a5\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>UserID<\/code> (INT): \uc0ac\uc6a9\uc790\uc758 \uace0\uc720 ID<\/li>\n\n\n\n<li><code>Username<\/code> (VARCHAR): \uc0ac\uc6a9\uc790 \uc774\ub984<\/li>\n\n\n\n<li><code>Orders<\/code> \ud14c\uc774\ube14: \uc8fc\ubb38 \uc815\ubcf4\ub97c \uc800\uc7a5\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>OrderID<\/code> (INT): \uc8fc\ubb38\uc758 \uace0\uc720 ID<\/li>\n\n\n\n<li><code>UserID<\/code> (INT): \uc8fc\ubb38\uc744 \ud55c \uc0ac\uc6a9\uc790\uc758 ID<\/li>\n\n\n\n<li><code>OrderDate<\/code> (DATE): \uc8fc\ubb38 \ub0a0\uc9dc<\/li>\n\n\n\n<li><code>Amount<\/code> (DECIMAL): \uc8fc\ubb38 \uae08\uc561<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">INNER JOIN \uc0ac\uc6a9 \uc608\uc81c<\/h3>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#0F111A\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" data-code=\"SELECT Users.Username, Orders.OrderDate, Orders.Amount\nFROM Users\nINNER JOIN Orders ON Users.UserID = Orders.UserID\nORDER BY Orders.OrderDate;\" style=\"color:#babed8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki material-theme-ocean\" style=\"background-color: #0F111A\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F78C6C\">SELECT<\/span><span style=\"color: #BABED8\"> Users.Username, Orders.OrderDate, Orders.Amount<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F78C6C\">FROM<\/span><span style=\"color: #BABED8\"> Users<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F78C6C\">INNER JOIN<\/span><span style=\"color: #BABED8\"> Orders <\/span><span style=\"color: #F78C6C\">ON<\/span><span style=\"color: #BABED8\"> Users.UserID <\/span><span style=\"color: #89DDFF\">=<\/span><span style=\"color: #BABED8\"> Orders.UserID<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F78C6C\">ORDER BY<\/span><span style=\"color: #BABED8\"> Orders.OrderDate;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>\uc774 \ucffc\ub9ac\ub294 <code>Users<\/code> \ud14c\uc774\ube14\uacfc <code>Orders<\/code> \ud14c\uc774\ube14\uc744 <code>UserID<\/code>\ub97c \uae30\uc900\uc73c\ub85c \uc870\uc778\ud558\uc5ec, \ub450 \ud14c\uc774\ube14\uc5d0 \ubaa8\ub450 \uc874\uc7ac\ud558\ub294 \uc0ac\uc6a9\uc790\uc758 \uc8fc\ubb38 \uc815\ubcf4\ub97c \uc870\ud68c\ud569\ub2c8\ub2e4. \uacb0\uacfc\ub85c\ub294 \ub9e4\uce6d\ub418\ub294 \uc0ac\uc6a9\uc790\uc758 \uc774\ub984, \uc8fc\ubb38 \ub0a0\uc9dc, \uadf8\ub9ac\uace0 \uc8fc\ubb38 \uae08\uc561\uc774 \ubc18\ud658\ub429\ub2c8\ub2e4. <code>INNER JOIN<\/code>\uc744 \uc0ac\uc6a9\ud558\ubbc0\ub85c, \ub450 \ud14c\uc774\ube14\uc5d0 \ubaa8\ub450 \ub9e4\uce6d\ub418\ub294 \ud589\ub9cc \uacb0\uacfc\uc5d0 \ud3ec\ud568\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc774 \uc608\uc81c\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uad00\uacc4\ub97c \ub9fa\uace0 \uc788\ub294 \ub450 \uac1c\uc758 \ud14c\uc774\ube14\uc5d0\uc11c \uad00\ub828 \ub370\uc774\ud130\ub97c \uacb0\ud569\ud558\uc5ec \uc870\ud68c\ud558\ub294 \uae30\ubcf8\uc801\uc778 \ubc29\ubc95\uc744 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. <code>INNER JOIN<\/code>\uc740 \ud14c\uc774\ube14 \uac04\uc758 \uad00\uacc4\ub97c \ud1b5\ud574 \uc5f0\uacb0\ub41c \ub370\uc774\ud130\ub97c \ucd94\ucd9c\ud560 \ub54c \ub9e4\uc6b0 \uc720\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>sql \uc815\ub9ac \ub0b4\uc6a9 join, delete<\/p>\n","protected":false},"author":1,"featured_media":1693,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[1],"tags":[154,153,117],"_links":{"self":[{"href":"https:\/\/dohokin.com\/index.php?rest_route=\/wp\/v2\/posts\/1690"}],"collection":[{"href":"https:\/\/dohokin.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dohokin.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dohokin.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dohokin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1690"}],"version-history":[{"count":1,"href":"https:\/\/dohokin.com\/index.php?rest_route=\/wp\/v2\/posts\/1690\/revisions"}],"predecessor-version":[{"id":1694,"href":"https:\/\/dohokin.com\/index.php?rest_route=\/wp\/v2\/posts\/1690\/revisions\/1694"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dohokin.com\/index.php?rest_route=\/wp\/v2\/media\/1693"}],"wp:attachment":[{"href":"https:\/\/dohokin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1690"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dohokin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1690"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dohokin.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1690"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}