{"id":7579,"date":"2024-10-31T05:23:37","date_gmt":"2024-10-31T05:23:37","guid":{"rendered":"https:\/\/pohang.eduwp.kr\/?p=7579"},"modified":"2026-04-20T04:31:03","modified_gmt":"2026-04-20T04:31:03","slug":"%ec%8b%a4%ec%8a%b5sql-%ec%bf%bc%eb%a6%ac-%ea%b5%ac%eb%ac%b8","status":"publish","type":"post","link":"https:\/\/pohang.eduwp.kr\/?p=7579","title":{"rendered":"\uc2e4\uc2b5sql \ucffc\ub9ac \uad6c\ubb38"},"content":{"rendered":"
sqlDB<\/a><\/div>\n
<\/div>\n
DROP DATABASE IF EXISTS sqldb; — \ub9cc\uc57d sqldb\uac00 \uc874\uc7ac\ud558\uba74 \uc6b0\uc120 \uc0ad\uc81c\ud55c\ub2e4.<\/div>\n
CREATE DATABASE sqldb;<\/div>\n
<\/div>\n
USE sqldb;<\/div>\n
CREATE TABLE usertbl — \ud68c\uc6d0 \ud14c\uc774\ube14<\/div>\n
( userID\u00a0\u00a0 CHAR(8) NOT NULL PRIMARY KEY, — \uc0ac\uc6a9\uc790 \uc544\uc774\ub514(PK)<\/div>\n
\u00a0 name\u00a0 \u00a0\u00a0 VARCHAR(10) NOT NULL, — \uc774\ub984<\/div>\n
\u00a0 birthYear\u00a0 \u00a0INT NOT NULL,\u00a0 — \ucd9c\uc0dd\ub144\ub3c4<\/div>\n
\u00a0 addr \u00a0\u00a0 CHAR(2) NOT NULL, — \uc9c0\uc5ed(\uacbd\uae30,\uc11c\uc6b8,\uacbd\ub0a8 \uc2dd\uc73c\ub85c 2\uae00\uc790\ub9cc\uc785\ub825)<\/div>\n
\u00a0 mobile1 CHAR(3), — \ud734\ub300\ud3f0\uc758 \uad6d\ubc88(011, 016, 017, 018, 019, 010 \ub4f1)<\/div>\n
\u00a0 mobile2 CHAR(8), — \ud734\ub300\ud3f0\uc758 \ub098\uba38\uc9c0 \uc804\ud654\ubc88\ud638(\ud558\uc774\ud508\uc81c\uc678)<\/div>\n
\u00a0 height\u00a0 \u00a0\u00a0 SMALLINT,\u00a0 — \ud0a4<\/div>\n
\u00a0 mDate\u00a0 \u00a0\u00a0 DATE\u00a0 — \ud68c\uc6d0 \uac00\uc785\uc77c<\/div>\n
);<\/div>\n
CREATE TABLE buytbl — \ud68c\uc6d0 \uad6c\ub9e4 \ud14c\uc774\ube14(Buy Table\uc758 \uc57d\uc790)<\/div>\n
(\u00a0 num\u00a0 INT AUTO_INCREMENT NOT NULL PRIMARY KEY, — \uc21c\ubc88(PK)<\/div>\n
\u00a0 \u00a0userID\u00a0\u00a0 CHAR(8) NOT NULL, — \uc544\uc774\ub514(FK)<\/div>\n
\u00a0 \u00a0prodName\u00a0 CHAR(6) NOT NULL, —\u00a0 \ubb3c\ud488\uba85<\/div>\n
\u00a0 \u00a0groupName\u00a0 CHAR(4)\u00a0 , — \ubd84\ub958<\/div>\n
\u00a0 \u00a0price\u00a0 \u00a0 \u00a0 INT\u00a0 NOT NULL, — \ub2e8\uac00<\/div>\n
\u00a0 \u00a0amount\u00a0 \u00a0\u00a0 SMALLINT\u00a0 NOT NULL, — \uc218\ub7c9<\/div>\n
\u00a0 \u00a0FOREIGN KEY (userID) REFERENCES usertbl(userID)<\/div>\n
);<\/div>\n
<\/div>\n
INSERT INTO usertbl VALUES(‘LSG’, ‘\uc774\uc2b9\uae30’, 1987, ‘\uc11c\uc6b8’, ‘011’, ‘1111111’, 182, ‘2008-8-8’);<\/div>\n
INSERT INTO usertbl VALUES(‘KBS’, ‘\uae40\ubc94\uc218’, 1979, ‘\uacbd\ub0a8’, ‘011’, ‘2222222’, 173, ‘2012-4-4’);<\/div>\n
INSERT INTO usertbl VALUES(‘KKH’, ‘\uae40\uacbd\ud638’, 1971, ‘\uc804\ub0a8’, ‘019’, ‘3333333’, 177, ‘2007-7-7’);<\/div>\n
INSERT INTO usertbl VALUES(‘JYP’, ‘\uc870\uc6a9\ud544’, 1950, ‘\uacbd\uae30’, ‘011’, ‘4444444’, 166, ‘2009-4-4’);<\/div>\n
INSERT INTO usertbl VALUES(‘SSK’, ‘\uc131\uc2dc\uacbd’, 1979, ‘\uc11c\uc6b8’, NULL\u00a0 , NULL\u00a0 \u00a0 \u00a0 , 186, ‘2013-12-12’);<\/div>\n
INSERT INTO usertbl VALUES(‘LJB’, ‘\uc784\uc7ac\ubc94’, 1963, ‘\uc11c\uc6b8’, ‘016’, ‘6666666’, 182, ‘2009-9-9’);<\/div>\n
INSERT INTO usertbl VALUES(‘YJS’, ‘\uc724\uc885\uc2e0’, 1969, ‘\uacbd\ub0a8’, NULL\u00a0 , NULL\u00a0 \u00a0 \u00a0 , 170, ‘2005-5-5’);<\/div>\n
INSERT INTO usertbl VALUES(‘EJW’, ‘\uc740\uc9c0\uc6d0’, 1972, ‘\uacbd\ubd81’, ‘011’, ‘8888888’, 174, ‘2014-3-3’);<\/div>\n
INSERT INTO usertbl VALUES(‘JKW’, ‘\uc870\uad00\uc6b0’, 1965, ‘\uacbd\uae30’, ‘018’, ‘9999999’, 172, ‘2010-10-10’);<\/div>\n
INSERT INTO usertbl VALUES(‘BBK’, ‘\ubc14\ube44\ud0b4’, 1973, ‘\uc11c\uc6b8’, ‘010’, ‘0000000’, 176, ‘2013-5-5’);<\/div>\n
INSERT INTO buytbl VALUES(NULL, ‘KBS’, ‘\uc6b4\ub3d9\ud654’, NULL\u00a0 \u00a0, 30,\u00a0 \u00a02);<\/div>\n
INSERT INTO buytbl VALUES(NULL, ‘KBS’, ‘\ub178\ud2b8\ubd81’, ‘\uc804\uc790’, 1000, 1);<\/div>\n
INSERT INTO buytbl VALUES(NULL, ‘JYP’, ‘\ubaa8\ub2c8\ud130’, ‘\uc804\uc790’, 200,\u00a0 1);<\/div>\n
INSERT INTO buytbl VALUES(NULL, ‘BBK’, ‘\ubaa8\ub2c8\ud130’, ‘\uc804\uc790’, 200,\u00a0 5);<\/div>\n
INSERT INTO buytbl VALUES(NULL, ‘KBS’, ‘\uccad\ubc14\uc9c0’, ‘\uc758\ub958’, 50,\u00a0 \u00a03);<\/div>\n
INSERT INTO buytbl VALUES(NULL, ‘BBK’, ‘\uba54\ubaa8\ub9ac’, ‘\uc804\uc790’, 80,\u00a0 10);<\/div>\n
INSERT INTO buytbl VALUES(NULL, ‘SSK’, ‘\ucc45’\u00a0 \u00a0 , ‘\uc11c\uc801’, 15,\u00a0 \u00a05);<\/div>\n
INSERT INTO buytbl VALUES(NULL, ‘EJW’, ‘\ucc45’\u00a0 \u00a0 , ‘\uc11c\uc801’, 15,\u00a0 \u00a02);<\/div>\n
INSERT INTO buytbl VALUES(NULL, ‘EJW’, ‘\uccad\ubc14\uc9c0’, ‘\uc758\ub958’, 50,\u00a0 \u00a01);<\/div>\n
INSERT INTO buytbl VALUES(NULL, ‘BBK’, ‘\uc6b4\ub3d9\ud654’, NULL\u00a0 \u00a0, 30,\u00a0 \u00a02);<\/div>\n
INSERT INTO buytbl VALUES(NULL, ‘EJW’, ‘\ucc45’\u00a0 \u00a0 , ‘\uc11c\uc801’, 15,\u00a0 \u00a01);<\/div>\n
INSERT INTO buytbl VALUES(NULL, ‘BBK’, ‘\uc6b4\ub3d9\ud654’, NULL\u00a0 \u00a0, 30,\u00a0 \u00a02);<\/div>\n
<\/div>\n
SELECT * FROM usertbl;<\/div>\n
SELECT * FROM buytbl;<\/div>\n
<\/div>\n
———————<\/div>\n
<\/div>\n
<\/div>\n
\n
DROP DATABASE IF EXISTS sqldb; -- \ub9cc\uc57d sqldb\uac00 \uc874\uc7ac\ud558\uba74 \uc6b0\uc120 \uc0ad\uc81c\ud55c\ub2e4.\r\nCREATE DATABASE sqldb;\r\n\r\nUSE sqldb;\r\nCREATE TABLE usertbl -- \ud68c\uc6d0 \ud14c\uc774\ube14\r\n( userID  \tCHAR(8) NOT NULL PRIMARY KEY, -- \uc0ac\uc6a9\uc790 \uc544\uc774\ub514(PK)\r\n  name    \tVARCHAR(10) NOT NULL, -- \uc774\ub984\r\n  birthYear   INT NOT NULL,  -- \ucd9c\uc0dd\ub144\ub3c4\r\n  addr\t  \tCHAR(2) NOT NULL, -- \uc9c0\uc5ed(\uacbd\uae30,\uc11c\uc6b8,\uacbd\ub0a8 \uc2dd\uc73c\ub85c 2\uae00\uc790\ub9cc\uc785\ub825)\r\n  mobile1\tCHAR(3), -- \ud734\ub300\ud3f0\uc758 \uad6d\ubc88(011, 016, 017, 018, 019, 010 \ub4f1)\r\n  mobile2\tCHAR(8), -- \ud734\ub300\ud3f0\uc758 \ub098\uba38\uc9c0 \uc804\ud654\ubc88\ud638(\ud558\uc774\ud508\uc81c\uc678)\r\n  height    \tSMALLINT,  -- \ud0a4\r\n  mDate    \tDATE  -- \ud68c\uc6d0 \uac00\uc785\uc77c\r\n);\r\nCREATE TABLE buytbl -- \ud68c\uc6d0 \uad6c\ub9e4 \ud14c\uc774\ube14(Buy Table\uc758 \uc57d\uc790)\r\n(  num \t\tINT AUTO_INCREMENT NOT NULL PRIMARY KEY, -- \uc21c\ubc88(PK)\r\n   userID  \tCHAR(8) NOT NULL, -- \uc544\uc774\ub514(FK)\r\n   prodName \tCHAR(6) NOT NULL, --  \ubb3c\ud488\uba85\r\n   groupName \tCHAR(4)  , -- \ubd84\ub958\r\n   price     \tINT  NOT NULL, -- \ub2e8\uac00\r\n   amount    \tSMALLINT  NOT NULL, -- \uc218\ub7c9\r\n   FOREIGN KEY (userID) REFERENCES usertbl(userID)\r\n);\r\n\r\nINSERT 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\r\nSELECT * FROM usertbl;\r\nSELECT * FROM buytbl;\r\n<\/pre>\n
 <\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
sqlDB DROP DATABASE IF EXISTS sqldb; — \ub9cc\uc57d sqldb\uac00 \uc874\uc7ac\ud558\uba74 \uc6b0\uc120 \uc0ad\uc81c\ud55c\ub2e4. CREATE DATABASE sqldb; USE sqldb; CREATE TABLE usertbl — \ud68c\uc6d0 \ud14c\uc774\ube14 ( userID\u00a0\u00a0 CHAR(8) NOT NULL PRIMARY KEY,…<\/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-7579","post","type-post","status-publish","format-standard","category-mysql"],"_links":{"self":[{"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/posts\/7579","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=7579"}],"version-history":[{"count":5,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/posts\/7579\/revisions"}],"predecessor-version":[{"id":7586,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/posts\/7579\/revisions\/7586"}],"wp:attachment":[{"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7579"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7579"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7579"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}