{"id":1710,"date":"2024-02-02T12:16:33","date_gmt":"2024-02-02T03:16:33","guid":{"rendered":"https:\/\/dohokin.com\/?p=1710"},"modified":"2024-02-02T12:16:34","modified_gmt":"2024-02-02T03:16:34","slug":"sql-%ed%85%8c%ec%9d%b4%eb%b8%94-%ec%88%98%ec%a0%95%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/dohokin.com\/?p=1710","title":{"rendered":"sql \ud14c\uc774\ube14 \uc218\uc815\ud558\uae30"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n

customerNumber<\/code> \ud544\ub4dc\ub97c AUTO_INCREMENT<\/code> \uae30\ubcf8 \ud0a4(Primary Key)\ub85c \uc124\uc815\ud558\ub824\uba74, \uba3c\uc800 \ud574\ub2f9 \ud544\ub4dc\ub97c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud14c\uc774\ube14\uc5d0 AUTO_INCREMENT<\/code> \uc18d\uc131\uacfc \ud568\uaed8 \uae30\ubcf8 \ud0a4\ub85c \uc9c0\uc815\ud574\uc57c \ud569\ub2c8\ub2e4. \uc774 \uc791\uc5c5\uc740 \ud14c\uc774\ube14\uc744 \ucc98\uc74c \uc0dd\uc131\ud560 \ub54c \ud558\uac70\ub098, \uc774\ubbf8 \uc874\uc7ac\ud558\ub294 \ud14c\uc774\ube14\uc744 \uc218\uc815\ud558\uc5ec \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\ud14c\uc774\ube14 \uc0dd\uc131 \uc2dc<\/h3>\n\n\n\n

\ud14c\uc774\ube14\uc744 \ucc98\uc74c \uc0dd\uc131\ud560 \ub54c\ub294 customerNumber<\/code> \ud544\ub4dc\ub97c AUTO_INCREMENT<\/code>\uc640 PRIMARY KEY<\/code>\ub85c \uc9c0\uc815\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4:<\/p>\n\n\n\n

<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
CREATE<\/span> <\/span>TABLE<\/span> <\/span>customers<\/span> (<\/span><\/span>\n    customerNumber <\/span>INT<\/span> AUTO_INCREMENT <\/span>PRIMARY KEY<\/span>,<\/span><\/span>\n    customerName <\/span>VARCHAR<\/span>(<\/span>255<\/span>),<\/span><\/span>\n    contactLastName <\/span>VARCHAR<\/span>(<\/span>255<\/span>),<\/span><\/span>\n    contactFirstName <\/span>VARCHAR<\/span>(<\/span>255<\/span>),<\/span><\/span>\n    phone <\/span>VARCHAR<\/span>(<\/span>255<\/span>),<\/span><\/span>\n    addressLine1 <\/span>VARCHAR<\/span>(<\/span>255<\/span>),<\/span><\/span>\n    addressLine2 <\/span>VARCHAR<\/span>(<\/span>255<\/span>),<\/span><\/span>\n    city <\/span>VARCHAR<\/span>(<\/span>255<\/span>),<\/span><\/span>\n    <\/span>state<\/span> <\/span>VARCHAR<\/span>(<\/span>255<\/span>),<\/span><\/span>\n    postalCode <\/span>VARCHAR<\/span>(<\/span>255<\/span>),<\/span><\/span>\n    country <\/span>VARCHAR<\/span>(<\/span>255<\/span>),<\/span><\/span>\n    salesRepEmployeeNumber <\/span>INT<\/span>,<\/span><\/span>\n    creditLimit <\/span>DECIMAL<\/span>(<\/span>10<\/span>,<\/span>2<\/span>)<\/span><\/span>\n);<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
\uc774\ubbf8 \uc874\uc7ac\ud558\ub294 \ud14c\uc774\ube14 \uc218\uc815<\/h3>\n\n\n\n
\uc774\ubbf8 \uc874\uc7ac\ud558\ub294 customers<\/code> \ud14c\uc774\ube14\uc5d0\uc11c customerNumber<\/code> \ud544\ub4dc\ub97c AUTO_INCREMENT<\/code> \uae30\ubcf8 \ud0a4\ub85c \ubcc0\uacbd\ud558\ub824\uba74, \uba3c\uc800 \uae30\uc874\uc758 \uae30\ubcf8 \ud0a4\uac00 \uc5c6\uac70\ub098 \ubcc0\uacbd\ud558\ub824\ub294 \uacbd\uc6b0 \uae30\uc874 \uae30\ubcf8 \ud0a4\ub97c \uc81c\uac70\ud574\uc57c \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uadf8 \ud6c4\uc5d0 customerNumber<\/code>\ub97c AUTO_INCREMENT<\/code> \uae30\ubcf8 \ud0a4\ub85c \uc124\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uba3c\uc800, \ud14c\uc774\ube14\uc758 \ud604\uc7ac \uc0c1\ud0dc\uc640 \uc678\ub798 \ud0a4 \uc81c\uc57d \uc870\uac74 \ub4f1\uc744 \ud655\uc778\ud574\uc57c \ud569\ub2c8\ub2e4. \uc774 \uacfc\uc815\uc5d0\uc11c \ub370\uc774\ud130 \uc190\uc2e4\uc774 \ubc1c\uc0dd\ud558\uc9c0 \uc54a\ub3c4\ub85d \uc8fc\uc758\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n
\ub2e4\uc74c\uc740 customerNumber<\/code> \ud544\ub4dc\ub97c AUTO_INCREMENT<\/code> \uae30\ubcf8 \ud0a4\ub85c \uc124\uc815\ud558\ub294 \ubc29\ubc95\uc758 \uc608\uc2dc\uc785\ub2c8\ub2e4:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
ALTER<\/span> <\/span>TABLE<\/span> customers <\/span>MODIFY<\/span> COLUMN customerNumber <\/span>INT<\/span> AUTO_INCREMENT <\/span>PRIMARY KEY<\/span>;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
\uc774 \uba85\ub839\uc740 customers<\/code> \ud14c\uc774\ube14\uc5d0 \uc788\ub294 customerNumber<\/code> \uc5f4\uc758 \ud0c0\uc785\uc744 INT AUTO_INCREMENT<\/code>\ub85c \ubcc0\uacbd\ud558\uace0, \uadf8\uac83\uc744 \uae30\ubcf8 \ud0a4\ub85c \uc9c0\uc815\ud569\ub2c8\ub2e4. \uc774\ubbf8 customerNumber<\/code>\uac00 \uae30\ubcf8 \ud0a4\ub85c \uc124\uc815\ub418\uc5b4 \uc788\uace0, \ub2e8\uc9c0 AUTO_INCREMENT<\/code> \uc18d\uc131\ub9cc \ucd94\uac00\ud558\ub824\ub294 \uacbd\uc6b0, \uc774 \uba85\ub839\uc774 \uc801\uc808\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n
\uc911\uc694 \uc0ac\ud56d<\/strong>: AUTO_INCREMENT<\/code> \uc18d\uc131\uc744 \ucd94\uac00\ud558\uae30 \uc804\uc5d0, \ud574\ub2f9 \uc5f4\uc5d0 \uc911\ubcf5\ub418\uac70\ub098 \ub204\ub77d\ub41c \uac12\uc774 \uc5c6\ub294\uc9c0, \uadf8\ub9ac\uace0 \ubaa8\ub4e0 \ud589\uc774 \uc720\ub2c8\ud06c\ud55c \uc2dd\ubcc4 \ubc88\ud638\ub97c \uac00\uc9c0\uace0 \uc788\ub294\uc9c0 \ud655\uc778\ud574\uc57c \ud569\ub2c8\ub2e4. \ub610\ud55c, \uc774 \ubcc0\uacbd\uc744 \uc218\ud589\ud558\uae30 \uc804\uc5d0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ubc31\uc5c5\uc744 \uc218\ud589\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n
ALTER TABLE customers MODIFY COLUMN customerNumber INT AUTO_INCREMENT Error Code: 1833. Cannot change column ‘customerNumber’: used in a foreign key constraint ‘payments_ibfk_1’ of table ‘classicmodels.payments’ 0.015 sec<\/p>\n\n\n\n
\uc624\ub958 \ucf54\ub4dc 1833\uc740 customerNumber<\/code> \uc5f4\uc774 \uc678\ub798 \ud0a4 \uc81c\uc57d \uc870\uac74 payments_ibfk_1<\/code>\uc5d0 \uc0ac\uc6a9\ub418\uace0 \uc788\uae30 \ub54c\ubb38\uc5d0, \uc774 \uc5f4\uc744 \ubcc0\uacbd\ud560 \uc218 \uc5c6\uc74c\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4. \uc774 \ubb38\uc81c\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud574, \ub2e4\uc74c \ub2e8\uacc4\ub97c \ub530\ub77c\uc57c \ud569\ub2c8\ub2e4:<\/p>\n\n\n\n
    \n
  1. \uc678\ub798 \ud0a4 \uc81c\uc57d \uc870\uac74 \uc81c\uac70<\/strong>: \uba3c\uc800, \ubb38\uc81c\uac00 \ub418\ub294 \uc678\ub798 \ud0a4 \uc81c\uc57d \uc870\uac74\uc744 \uc81c\uac70\ud569\ub2c8\ub2e4. \uc774\ub294 customerNumber<\/code> \uc5f4\uc744 \ubcc0\uacbd\ud560 \uc218 \uc788\uac8c \ud574\uc90d\ub2c8\ub2e4.<\/li>\n\n\n\n
  2. \uc5f4 \uc218\uc815<\/strong>: \ud544\uc694\ud55c \ubcc0\uacbd\uc744 \uc218\ud589\ud569\ub2c8\ub2e4 (customerNumber<\/code> \uc5f4\uc5d0 AUTO_INCREMENT<\/code> \uc18d\uc131 \ucd94\uac00).<\/li>\n\n\n\n
  3. \uc678\ub798 \ud0a4 \uc81c\uc57d \uc870\uac74 \ucd94\uac00<\/strong>: \ubcc0\uacbd \uc0ac\ud56d\uc744 \uc801\uc6a9\ud55c \ud6c4, \uc81c\uac70\ud588\ub358 \uc678\ub798 \ud0a4 \uc81c\uc57d \uc870\uac74\uc744 \ub2e4\uc2dc \ucd94\uac00\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n\n\n
    \ub2e8\uacc4\ubcc4 \ud574\uacb0 \ubc29\ubc95<\/h3>\n\n\n\n
    1. \uc678\ub798 \ud0a4 \uc81c\uc57d \uc870\uac74 \uc81c\uac70<\/h4>\n\n\n\n
    <\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
    ALTER<\/span> <\/span>TABLE<\/span> classicmodels.payments <\/span>DROP<\/span> <\/span>FOREIGN KEY<\/span> payments_ibfk_1;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
    2. \uc5f4 \uc218\uc815<\/h4>\n\n\n\n
    <\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
    ALTER<\/span> <\/span>TABLE<\/span> customers <\/span>MODIFY<\/span> COLUMN customerNumber <\/span>INT<\/span> AUTO_INCREMENT <\/span>PRIMARY KEY<\/span>;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
    3. \uc678\ub798 \ud0a4 \uc81c\uc57d \uc870\uac74 \ucd94\uac00<\/h4>\n\n\n\n
    \uc678\ub798 \ud0a4\ub97c \ub2e4\uc2dc \ucd94\uac00\ud558\uae30 \uc804\uc5d0, customerNumber<\/code>\uac00 AUTO_INCREMENT<\/code>\ub85c \uc124\uc815\ub418\uc5c8\uc73c\ubbc0\ub85c, \uad00\ub828 \ub370\uc774\ud130\uac00 \uc62c\ubc14\ub974\uac8c \ucc38\uc870\ub418\uace0 \uc788\ub294\uc9c0 \ud655\uc778\ud574\uc57c \ud569\ub2c8\ub2e4. \uadf8 \ud6c4, \ub2e4\uc74c \uba85\ub839\uc5b4\ub85c \uc678\ub798 \ud0a4\ub97c \ub2e4\uc2dc \ucd94\uac00\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n\n\n\n
    <\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
    ALTER<\/span> <\/span>TABLE<\/span> classicmodels.payments <\/span>ADD<\/span> <\/span>CONSTRAINT<\/span> payments_ibfk_1 <\/span>FOREIGN KEY<\/span> (customerNumber) <\/span>REFERENCES<\/span> customers(customerNumber);<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
    \uc8fc\uc758 \uc0ac\ud56d<\/h3>\n\n\n\n
      \n
    • \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc218\uc815\ud558\uae30 \uc804\uc5d0 \ubc18\ub4dc\uc2dc \ubc31\uc5c5\uc744 \uc218\ud589\ud558\uc138\uc694. \uc774\ub294 \ubcc0\uacbd \uc0ac\ud56d\uc774 \uc608\uae30\uce58 \uc54a\uc740 \ubd80\uc791\uc6a9\uc744 \uc77c\uc73c\ud0ac \uacbd\uc6b0 \uc6d0\ub798 \uc0c1\ud0dc\ub85c \ubcf5\uc6d0\ud560 \uc218 \uc788\uac8c \ud569\ub2c8\ub2e4.<\/li>\n\n\n\n
    • \uc678\ub798 \ud0a4 \uc81c\uc57d \uc870\uac74\uc744 \uc81c\uac70\ud558\uace0 \ub2e4\uc2dc \ucd94\uac00\ud558\ub294 \uacfc\uc815\uc5d0\uc11c, \uad00\ub828\ub41c \ubaa8\ub4e0 \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130 \ubb34\uacb0\uc131\uc744 \uc720\uc9c0\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4. \uc989, \ubaa8\ub4e0 customerNumber<\/code> \uac12\uc774 customers<\/code> \ud14c\uc774\ube14\uc758 \uae30\uc874 \ub808\ucf54\ub4dc\uc640 \uc77c\uce58\ud574\uc57c \ud569\ub2c8\ub2e4.<\/li>\n\n\n\n
    • \uc678\ub798 \ud0a4 \uc81c\uc57d \uc870\uac74\uc758 \uc774\ub984(payments_ibfk_1<\/code>)\uacfc \uad00\ub828 \ud14c\uc774\ube14 \uc774\ub984(classicmodels.payments<\/code>)\uc774 \uc608\uc2dc\uc5d0\uc11c \uc0ac\uc6a9\ub41c \uac83\ub4e4\uc774\ubbc0\ub85c, \uc2e4\uc81c \ud658\uacbd\uc5d0\uc11c\ub294 \uc774\ub4e4 \uc774\ub984\uc774 \ub2e4\ub97c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc801\uc808\ud55c \uc774\ub984\uc744 \uc0ac\uc6a9\ud574\uc57c \ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
      sql \ud14c\uc774\ube14 \uc218\uc815\ud558\uae30<\/p>\n","protected":false},"author":1,"featured_media":1712,"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":[159,160,117],"_links":{"self":[{"href":"https:\/\/dohokin.com\/index.php?rest_route=\/wp\/v2\/posts\/1710"}],"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=1710"}],"version-history":[{"count":1,"href":"https:\/\/dohokin.com\/index.php?rest_route=\/wp\/v2\/posts\/1710\/revisions"}],"predecessor-version":[{"id":1713,"href":"https:\/\/dohokin.com\/index.php?rest_route=\/wp\/v2\/posts\/1710\/revisions\/1713"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dohokin.com\/index.php?rest_route=\/wp\/v2\/media\/1712"}],"wp:attachment":[{"href":"https:\/\/dohokin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1710"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dohokin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1710"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dohokin.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1710"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}