{"id":7265,"date":"2024-08-31T08:36:10","date_gmt":"2024-08-31T08:36:10","guid":{"rendered":"https:\/\/pohang.eduwp.kr\/?p=7265"},"modified":"2026-04-20T04:31:03","modified_gmt":"2026-04-20T04:31:03","slug":"3%ec%a3%bc%ec%b0%a8-3","status":"publish","type":"post","link":"https:\/\/pohang.eduwp.kr\/?p=7265","title":{"rendered":"3\uc8fc\ucc28"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_81 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\">Table of Contents<\/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;\">Toggle<\/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-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/pohang.eduwp.kr\/?p=7265\/#%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%B2%A0%EC%9D%B4%EC%8A%A4_%EC%84%A0%ED%83%9D%ED%95%98%EA%B8%B0\" >\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc120\ud0dd\ud558\uae30<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/pohang.eduwp.kr\/?p=7265\/#%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%B2%A0%EC%9D%B4%EC%8A%A4_%EC%A0%84%EC%B2%B4_%EB%AA%A9%EB%A1%9D%EB%B3%B4%EA%B8%B0\" >\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc804\uccb4 \ubaa9\ub85d\ubcf4\uae30<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/pohang.eduwp.kr\/?p=7265\/#%EB%8D%B0%EC%9D%B4%ED%84%B0_%EB%B2%A0%EC%9D%B4%EC%8A%A4_%EC%82%AC%EC%9A%A9\" >\ub370\uc774\ud130 \ubca0\uc774\uc2a4 \uc0ac\uc6a9<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/pohang.eduwp.kr\/?p=7265\/#%EC%84%A0%ED%83%9D%ED%95%9C_%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%B2%A0%EC%9D%B4%EC%8A%A4%EC%9D%98_%EC%A0%84%EC%B2%B4_%ED%85%8C%EC%9D%B4%EB%B8%94_%EC%83%81%ED%83%9C%EB%B3%B4%EA%B8%B0_%ED%85%8C%EC%9D%B4%EB%B8%94_%EC%A2%85%EB%A5%98%EB%B3%B4%EA%B8%B0_%ED%95%84%EB%93%9C%EA%B5%AC%EC%84%B1%EC%9A%94%EC%86%8C%EB%B3%B4%EA%B8%B0\" >\uc120\ud0dd\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc804\uccb4 \ud14c\uc774\ube14 \uc0c1\ud0dc\ubcf4\uae30, \ud14c\uc774\ube14 \uc885\ub958\ubcf4\uae30, \ud544\ub4dc\uad6c\uc131\uc694\uc18c\ubcf4\uae30<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/pohang.eduwp.kr\/?p=7265\/#%EC%84%A0%ED%83%9D%ED%95%9C_%ED%85%8C%EC%9D%B4%EB%B8%94_%EB%82%B4%EC%9A%A9_%EB%B3%B4%EA%B8%B0\" >\uc120\ud0dd\ud55c \ud14c\uc774\ube14 \ub0b4\uc6a9 \ubcf4\uae30<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/pohang.eduwp.kr\/?p=7265\/#%EC%9B%90%ED%95%98%EB%8A%94_%ED%95%84%EB%93%9C%EC%BB%AC%EB%9F%BC%EB%A7%8C_%EB%B6%88%EB%9F%AC%EC%98%A4%EA%B3%A0_%EC%8B%B6%EC%9D%84%EB%95%8C_employees%EC%9D%98_titles_%ED%85%8C%EC%9D%B4%EB%B8%94%EC%9D%84_%EC%A1%B0%ED%9A%8C%EA%B8%B0%EC%A4%80\" >\uc6d0\ud558\ub294 \ud544\ub4dc(\uceec\ub7fc)\ub9cc \ubd88\ub7ec\uc624\uace0 \uc2f6\uc744\ub54c (employees\uc758 titles \ud14c\uc774\ube14\uc744 \uc870\ud68c\uae30\uc900)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/pohang.eduwp.kr\/?p=7265\/#%EB%B6%88%EB%9F%AC%EC%98%A4%EB%8A%94_%EC%88%AB%EC%9E%90_%EC%A0%9C%ED%95%9C%EC%84%A4%EC%A0%95%ED%95%98%EA%B8%B0\" >\ubd88\ub7ec\uc624\ub294 \uc22b\uc790 \uc81c\ud55c\uc124\uc815\ud558\uae30<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/pohang.eduwp.kr\/?p=7265\/#%EC%8B%A0%EA%B7%9C_%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%B2%A0%EC%9D%B4%EC%8A%A4_%EC%83%9D%EC%84%B1%ED%95%98%EA%B8%B0\" >\uc2e0\uaddc \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0dd\uc131\ud558\uae30<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/pohang.eduwp.kr\/?p=7265\/#%EC%83%98%ED%94%8C_%EB%8D%B0%EC%9D%B4%ED%84%B0_%EC%9E%85%EB%A0%A5%ED%95%98%EA%B8%B0\" >\uc0d8\ud50c \ub370\uc774\ud130 \uc785\ub825\ud558\uae30<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/pohang.eduwp.kr\/?p=7265\/#where_%EC%A1%B0%EA%B1%B4%EC%8B%9D_%EC%82%B4%ED%8E%B4%EB%B3%B4%EA%B8%B0\" >where \uc870\uac74\uc2dd \uc0b4\ud3b4\ubcf4\uae30<\/a><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%B2%A0%EC%9D%B4%EC%8A%A4_%EC%84%A0%ED%83%9D%ED%95%98%EA%B8%B0\"><\/span>\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc120\ud0dd\ud558\uae30<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%B2%A0%EC%9D%B4%EC%8A%A4_%EC%A0%84%EC%B2%B4_%EB%AA%A9%EB%A1%9D%EB%B3%B4%EA%B8%B0\"><\/span>\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc804\uccb4 \ubaa9\ub85d\ubcf4\uae30<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">show databases;<\/pre>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"%EB%8D%B0%EC%9D%B4%ED%84%B0_%EB%B2%A0%EC%9D%B4%EC%8A%A4_%EC%82%AC%EC%9A%A9\"><\/span>\ub370\uc774\ud130 \ubca0\uc774\uc2a4 \uc0ac\uc6a9<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">-- use db\uba85; --\r\nuse employees;<\/pre>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"%EC%84%A0%ED%83%9D%ED%95%9C_%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%B2%A0%EC%9D%B4%EC%8A%A4%EC%9D%98_%EC%A0%84%EC%B2%B4_%ED%85%8C%EC%9D%B4%EB%B8%94_%EC%83%81%ED%83%9C%EB%B3%B4%EA%B8%B0_%ED%85%8C%EC%9D%B4%EB%B8%94_%EC%A2%85%EB%A5%98%EB%B3%B4%EA%B8%B0_%ED%95%84%EB%93%9C%EA%B5%AC%EC%84%B1%EC%9A%94%EC%86%8C%EB%B3%B4%EA%B8%B0\"><\/span>\uc120\ud0dd\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc804\uccb4 \ud14c\uc774\ube14 \uc0c1\ud0dc\ubcf4\uae30, \ud14c\uc774\ube14 \uc885\ub958\ubcf4\uae30, \ud544\ub4dc\uad6c\uc131\uc694\uc18c\ubcf4\uae30<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">show table status;\r\nshow tables;\r\ndescribe \ud14c\uc774\ube14\uba85;\r\n\r\n-- \ud14c\uc774\ube14\uba85\uc774 usertbl\uc774\ub77c\uba74 --\r\ndescribe usertbl;\r\ndesc usertbl;<\/pre>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"%EC%84%A0%ED%83%9D%ED%95%9C_%ED%85%8C%EC%9D%B4%EB%B8%94_%EB%82%B4%EC%9A%A9_%EB%B3%B4%EA%B8%B0\"><\/span>\uc120\ud0dd\ud55c \ud14c\uc774\ube14 \ub0b4\uc6a9 \ubcf4\uae30<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\uc0ac\uc6a9\uc911\uc778 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud14c\uc774\ube14\uba85\uc744 \ubd88\ub7ec\uc624\uac70\ub098 db\uba85.\ud14c\uc774\ube14\uba85 \uc5f0\uacb0\ud574\uc11c \uc801\uc5b4\ub3c4 \ub41c\ub2e4.<br \/>\n\ubcf4\ud1b5 \ud604\uc7ac \uc0ac\uc6a9\uc911\uc778 DB\ub97c \uc120\ud0dd\ud55c \uacbd\uc6b0 \ud14c\uc774\ube14 \uc774\ub984\ub9cc \uc801\uc5b4\uc11c \uc0ac\uc6a9\ud55c\ub2e4.<br \/>\n\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ub2e4\ub978\uac83\uc774 \uc120\ud0dd\ub418\uc5b4 \uc788\uc744\ub54c \ub2e4\ub978db\uba85\uc744 \ubc14\ub85c \uc870\ud68c\ud560\ub54c db\uba85\ub3c4 \uac19\uc774 \uc801\uc5b4\uc900\ub2e4.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">select * from employees;\r\nselect * from employees.employees;<\/pre>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"%EC%9B%90%ED%95%98%EB%8A%94_%ED%95%84%EB%93%9C%EC%BB%AC%EB%9F%BC%EB%A7%8C_%EB%B6%88%EB%9F%AC%EC%98%A4%EA%B3%A0_%EC%8B%B6%EC%9D%84%EB%95%8C_employees%EC%9D%98_titles_%ED%85%8C%EC%9D%B4%EB%B8%94%EC%9D%84_%EC%A1%B0%ED%9A%8C%EA%B8%B0%EC%A4%80\"><\/span>\uc6d0\ud558\ub294 \ud544\ub4dc(\uceec\ub7fc)\ub9cc \ubd88\ub7ec\uc624\uace0 \uc2f6\uc744\ub54c (employees\uc758 titles \ud14c\uc774\ube14\uc744 \uc870\ud68c\uae30\uc900)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">select emp_no,title, from_date, to_date from titles;\r\n\r\nselect * from titles;<\/pre>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"%EB%B6%88%EB%9F%AC%EC%98%A4%EB%8A%94_%EC%88%AB%EC%9E%90_%EC%A0%9C%ED%95%9C%EC%84%A4%EC%A0%95%ED%95%98%EA%B8%B0\"><\/span>\ubd88\ub7ec\uc624\ub294 \uc22b\uc790 \uc81c\ud55c\uc124\uc815\ud558\uae30<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>limit \uc635\uc158<\/p>\n<p>&nbsp;<\/p>\n<hr \/>\n<h1><span class=\"ez-toc-section\" id=\"%EC%8B%A0%EA%B7%9C_%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%B2%A0%EC%9D%B4%EC%8A%A4_%EC%83%9D%EC%84%B1%ED%95%98%EA%B8%B0\"><\/span>\uc2e0\uaddc \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0dd\uc131\ud558\uae30<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>&nbsp;<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">DROP DATABASE IF EXISTS sqldb;   -- \uae30\uc874\uc5d0 sqldb \uc774\ub984\uc774 \uc788\ub2e4\uba74 \uc0ad\uc81c\uc2dc\ucf1c\ub77c , \ub9e4\uc6b0 \uc870\uc2ec\ud574\uc57c\ud568 --\r\n\r\nCREATE DATABASE sqldb; \r\n\r\nUSE sqldb;\r\n\r\nCREATE TABLE usertbl (\r\n    userID char(8) not null PRIMARY KEY,  -- \ud68c\uc6d0 \uc544\uc774\ub514 --\r\n    name VARCHAR(10) NOT NULL,  -- \ud68c\uc6d0\uc774\ub984 --\r\n    birtthYear int not null, -- \uc0dd\ub144\uc6d4\uc77c --\r\n    addr char(2) not null, -- \uc9c0\uc5ed\uad6c\ubd84 --\r\n    mobile1 char(3), -- \ud734\ub300\ud3f0 \uc55e\uc790\ub9ac --\r\n    mobile2 char(8), -- \ud734\ub300\ud3f0 \uc911\uac04,\ub4b7 --\r\n    height SMALLINT, -- \ud0a4 --\r\n    mDate DATE -- \ud68c\uc6d0\uac00\uc785\uc77c --\r\n);\r\n\r\n<\/pre>\n<div>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">CREATE TABLE buytbl \r\n(\r\n    num int AUTO_INCREMENT not null PRIMARY\tKEY,\r\n    userID char(8) not null,\r\n    prodName char(6) not null,\r\n    groupName char(4), \r\n    price INT not null,\r\n    amount SMALLINT not null,\r\n    FOREIGN KEY(userId) REFERENCES usertbl(userID)\r\n);<\/pre>\n<\/div>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">show TABLE STATUS;\r\nshow TABLES;\r\ndesc usertbl;<\/pre>\n<p>&nbsp;<\/p>\n<h1><span class=\"ez-toc-section\" id=\"%EC%83%98%ED%94%8C_%EB%8D%B0%EC%9D%B4%ED%84%B0_%EC%9E%85%EB%A0%A5%ED%95%98%EA%B8%B0\"><\/span>\uc0d8\ud50c \ub370\uc774\ud130 \uc785\ub825\ud558\uae30<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>&nbsp;<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">INSERT INTO usertbl VALUES('LSG', '\uc774\uc2b9\uae30', 1987, '\uc11c\uc6b8', '011', '1111111', 182, '2008-8-8');\r\nINSERT INTO usertbl VALUES('KBS', '\uae40\ubc94\uc218', 1979, '\uacbd\ub0a8', '011', '2222222', 173, '2012-4-4');\r\nINSERT INTO usertbl VALUES('KKH', '\uae40\uacbd\ud638', 1971, '\uc804\ub0a8', '019', '3333333', 177, '2007-7-7');\r\nINSERT INTO usertbl VALUES('JYP', '\uc870\uc6a9\ud544', 1950, '\uacbd\uae30', '011', '4444444', 166, '2009-4-4');\r\nINSERT INTO usertbl VALUES('SSK', '\uc131\uc2dc\uacbd', 1979, '\uc11c\uc6b8', NULL  , NULL      , 186, '2013-12-12');\r\nINSERT INTO usertbl VALUES('LJB', '\uc784\uc7ac\ubc94', 1963, '\uc11c\uc6b8', '016', '6666666', 182, '2009-9-9');\r\nINSERT INTO usertbl VALUES('YJS', '\uc724\uc885\uc2e0', 1969, '\uacbd\ub0a8', NULL  , NULL      , 170, '2005-5-5');\r\nINSERT INTO usertbl VALUES('EJW', '\uc740\uc9c0\uc6d0', 1972, '\uacbd\ubd81', '011', '8888888', 174, '2014-3-3');\r\nINSERT INTO usertbl VALUES('JKW', '\uc870\uad00\uc6b0', 1965, '\uacbd\uae30', '018', '9999999', 172, '2010-10-10');\r\nINSERT INTO usertbl VALUES('BBK', '\ubc14\ube44\ud0b4', 1973, '\uc11c\uc6b8', '010', '0000000', 176, '2013-5-5');\r\nINSERT INTO buytbl VALUES(NULL, 'KBS', '\uc6b4\ub3d9\ud654', NULL   , 30,   2);\r\nINSERT INTO buytbl VALUES(NULL, 'KBS', '\ub178\ud2b8\ubd81', '\uc804\uc790', 1000, 1);\r\nINSERT INTO buytbl VALUES(NULL, 'JYP', '\ubaa8\ub2c8\ud130', '\uc804\uc790', 200,  1);\r\nINSERT INTO buytbl VALUES(NULL, 'BBK', '\ubaa8\ub2c8\ud130', '\uc804\uc790', 200,  5);\r\nINSERT INTO buytbl VALUES(NULL, 'KBS', '\uccad\ubc14\uc9c0', '\uc758\ub958', 50,   3);\r\nINSERT INTO buytbl VALUES(NULL, 'BBK', '\uba54\ubaa8\ub9ac', '\uc804\uc790', 80,  10);\r\nINSERT INTO buytbl VALUES(NULL, 'SSK', '\ucc45'    , '\uc11c\uc801', 15,   5);\r\nINSERT INTO buytbl VALUES(NULL, 'EJW', '\ucc45'    , '\uc11c\uc801', 15,   2);\r\nINSERT INTO buytbl VALUES(NULL, 'EJW', '\uccad\ubc14\uc9c0', '\uc758\ub958', 50,   1);\r\nINSERT INTO buytbl VALUES(NULL, 'BBK', '\uc6b4\ub3d9\ud654', NULL   , 30,   2);\r\nINSERT INTO buytbl VALUES(NULL, 'EJW', '\ucc45'    , '\uc11c\uc801', 15,   1);\r\nINSERT INTO buytbl VALUES(NULL, 'BBK', '\uc6b4\ub3d9\ud654', NULL   , 30,   2);\r\n<\/pre>\n<p>&nbsp;<\/p>\n<p>insert \uad6c\ubb38\uc5d0\uc11c \ubaa8\ub4e0\uac12\uc744 \uc785\ub825\ud558\uc9c0 \uc54a\uace0 \uc77c\ubd80\ub9cc \uc785\ub825\ud558\ub294 \uad6c\ubb38 \uc54c\uc544\ubcf4\uae30<\/p>\n<p>insert into usertbl (name, birthYear, addr) values (&#8216;\uae40\uc131\uae38&#8217;,1979,&#8217;\uacbd\ubd81&#8217;);\u00a0 \u00a0&#8212; \uc624\ub958\uac00 \ub098\ub294 \uc6d0\uc778\uc744 \uc0dd\uac01\ud574\ubcf4\uae30 &#8212;<\/p>\n<p>\ubd80\ubd84 \uc785\ub825\uc744 \uc704\ud574\uc11c\u00a0 \ud504\ub77c\uc774\uba38\ub9ac \ud0a4 \uac12\uc740 \ubc18\ub4dc\uc2dc \uc785\ub825\ud574\uc57c \ud55c\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">insert into usertbl (userid, name, birthYear, addr) values ('KSS','\uae40\uc131\uc2e4',1979,'\uacbd\ubd81');\u00a0 \u00a0-- \ubd80\ubd84 \uc785\ub825 --\u00a0\r\n\r\nupdate usertbl set mobile1 ='010', mobile2='85858585', height='170', mDate='2024-09-09' where userid ='KSS';\u00a0 -- \ube60\uc9c4 \ubd80\ubd84\uc744 \uc5c5\ub370\uc774\ud2b8 \ucc98\ub9ac\ud558\uae30 --<\/pre>\n<p>insert 3\uac74\uc744 \ud55c\uad6c\ubb38\uc5d0 \uc785\ub825\ud558\uae30<\/p>\n<p>&nbsp;<\/p>\n<p>insert into\u00a0 \ud14c\uc774\ube14\uc774\ub984 values (\uac121, \uac122&#8230;) , (\uac123, \uac124&#8230;), (\uac125,\uac126&#8230;)<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<div><\/div>\n<h1><span class=\"ez-toc-section\" id=\"where_%EC%A1%B0%EA%B1%B4%EC%8B%9D_%EC%82%B4%ED%8E%B4%EB%B3%B4%EA%B8%B0\"><\/span>where \uc870\uac74\uc2dd \uc0b4\ud3b4\ubcf4\uae30<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>where\ub294 \ub370\uc774\ud130\ub97c \ubd88\ub7ec\uc62c\ub54c \uc870\uac74\uc744 \uac78 \uc218 \uc788\ub2e4.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">select name from usertbl where ='\uc774\uc2b9\uae30';\u00a0 --&gt; \ud2c0\ub838\uc74c \uc5b4\ub514\uac00...\r\n\r\nselect name, height from usertbl;\r\n\r\nselect name, height from usertbl where birthYear &gt;= 1970 or height &gt;= 182;\r\n\r\nselect name, height from usertbl where height &gt;= 180 and height &lt;= 183;\r\n\r\nselect name, height from usertbl where height between 180 and 183;\r\n\r\nselect name, height from usertbl where height &gt;= 180 and height &lt;= 183;\r\n\r\nselect name, height from usertbl where addr='\uacbd\ubd81' or addr='\uc11c\uc6b8' or addr='\uc804\ubd81';\r\n\r\nselect name, height from usertbl where addr in ('\uacbd\ubd81','\uc11c\uc6b8','\uc804\ubd81');\r\n\r\nselect name, height from usertbl where name like '\uae40%';\r\nselect name, height from usertbl where name like '%\uae40%';\r\nselect name, height from usertbl where name like '%\uae40';\r\nselect name, height from usertbl where name like '_\uc885\uc2e0';\r\nselect name, height from usertbl where name like '\uae40__';\r\n\r\n<\/pre>\n<p>employee \ud14c\uc774\ube14\uc5d0\uc11c \uc544\ub798 \ucffc\ub9ac\uad6c\ubb38 \ud655\uc778\ud574\ubcf4\uae30<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">select emp_no, birth_date from employees where emp_no &lt; 15000 and birth_date like '%1953%' order by emp_no desc limit 2;<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc120\ud0dd\ud558\uae30 &nbsp; \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc804\uccb4 \ubaa9\ub85d\ubcf4\uae30 show databases; &nbsp; \ub370\uc774\ud130 \ubca0\uc774\uc2a4 \uc0ac\uc6a9 &#8212; use db\uba85; &#8212; use employees; &nbsp; \uc120\ud0dd\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc804\uccb4 \ud14c\uc774\ube14 \uc0c1\ud0dc\ubcf4\uae30, \ud14c\uc774\ube14 \uc885\ub958\ubcf4\uae30, \ud544\ub4dc\uad6c\uc131\uc694\uc18c\ubcf4\uae30 show table status;&#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-7265","post","type-post","status-publish","format-standard","category-mysql"],"_links":{"self":[{"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/posts\/7265","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=7265"}],"version-history":[{"count":5,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/posts\/7265\/revisions"}],"predecessor-version":[{"id":7434,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/posts\/7265\/revisions\/7434"}],"wp:attachment":[{"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7265"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7265"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7265"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}