{"id":1714,"date":"2024-02-02T12:25:38","date_gmt":"2024-02-02T03:25:38","guid":{"rendered":"https:\/\/dohokin.com\/?p=1714"},"modified":"2024-02-02T12:25:38","modified_gmt":"2024-02-02T03:25:38","slug":"sql-update%ed%95%a0%eb%95%8c-data-truncated-%ec%97%90%eb%9f%ac-%eb%b0%9c%ec%83%9d%ec%8b%9c","status":"publish","type":"post","link":"https:\/\/dohokin.com\/?p=1714","title":{"rendered":"sql UPDATE\ud560\ub54c Data truncated \uc5d0\ub7ec \ubc1c\uc0dd\uc2dc"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n

UPDATE products SET buyPrice = buyPrice * 1.10 WHERE productLine = ‘Classic Cars’; 1 123 12:16:56 UPDATE products SET buyPrice = buyPrice * 1.10 WHERE productLine = ‘Classic Cars’ 38 row(s) affected, 35 warning(s): 1265 Data truncated for column ‘buyPrice’ at row 1 1265 Data truncated for column ‘buyPrice’ at row 2 1265 Data truncated for column ‘buyPrice’ at row 3 1265 Data truncated for column ‘buyPrice’ at row 4 1265 Data truncated for column ‘buyPrice’ at row 5 1265 Data truncated for column ‘buyPrice’ at row 6 1265 Data truncated for column ‘buyPrice’ at row 7 1265 Data truncated for column ‘buyPrice’ at row 8 1265 Data truncated for column ‘buyPrice’ at row 9 1265 Data truncated for column ‘buyPrice’ at row 10 1265 Data truncated for column ‘buyPrice’ at row 11 1265 Data truncated for column ‘buyPrice’ at row 12 1265 Data truncated for column ‘buyPrice’ at row 14 1265 Data truncated for column ‘buyPrice’ at row 15 1265 Data truncated for column ‘buyPrice’ at row 16 1265 Data truncated for column ‘buyPrice’ at row 18 1265 Data truncated for column ‘buyPrice’ at row 19 1265 Data truncated for column ‘buyPrice’ at row 20 1265 Data truncated for column ‘buyPrice’ at row 21 1265 Data truncated for column ‘buyPrice’ at row 22 1265 Data truncated for column ‘buyPrice’ at row 23 1265 Data truncated for column ‘buyPrice’ at row 24 1265 Data truncated for column ‘buyPrice’ at row 25 1265 Data truncated for column ‘buyPrice’ at row 26 1265 Data truncated for column ‘buyPrice’ at row 27 1265 Data truncated for column ‘buyPrice’ at row 28 1265 Data truncated for column ‘buyPrice’ at row 29 1265 Data truncated for column ‘buyPrice’ at row 30 1265 Data truncated for column ‘buyPrice’ at row 31 1265 Data truncated for column ‘buyPrice’ at row 32 1265 Data truncated for column ‘buyPrice’ at row 33 1265 Data truncated for column ‘buyPrice’ at row 34 1265 Data truncated for column ‘buyPrice’ at row 36 1265 Data truncated for column ‘buyPrice’ at row 37 1265 Data truncated for column ‘buyPrice’ at row 38 Rows matched: 38 Changed: 38 Warnings: 35 0.015 sec<\/p>\n\n\n\n

\uacbd\uace0 \uba54\uc2dc\uc9c0 1265 Data truncated for column 'buyPrice' at row X<\/code>\ub294 buyPrice<\/code> \uc5f4\uc758 \ub370\uc774\ud130\uac00 \uc5c5\ub370\uc774\ud2b8 \uacfc\uc815\uc5d0\uc11c \uc77c\ubd80 \ub370\uc774\ud130\uac00 \ud574\ub2f9 \uc5f4\uc5d0 \uc124\uc815\ub41c \ub370\uc774\ud130 \ud0c0\uc785\uc774\ub098 \uae38\uc774\ub97c \ucd08\uacfc\ud558\uc5ec \uc790\ub974\uac8c \ub418\uc5c8\uc74c\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4. \uc774\ub294 \uc77c\ubc18\uc801\uc73c\ub85c \uc5f4\uc774 \uc800\uc7a5\ud560 \uc218 \uc788\ub294 \ucd5c\ub300\uac12\uc744 \ub118\uc5b4\uc11c\ub294 \uac12\uc744 \uc5c5\ub370\uc774\ud2b8\ud558\ub824 \ud560 \ub54c \ubc1c\uc0dd\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n

buyPrice<\/code> \uc5f4\uc758 \ub370\uc774\ud130 \ud0c0\uc785\uc744 \ud655\uc778\ud558\uace0, \ud544\uc694\ud558\ub2e4\uba74 \ub370\uc774\ud130 \ud0c0\uc785\uc744 \ubcc0\uacbd\ud558\uc5ec \ub354 \ud070 \uac12\uc744 \uc800\uc7a5\ud560 \uc218 \uc788\ub3c4\ub85d \uc870\uc815\ud574\uc57c \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, buyPrice<\/code>\uac00 DECIMAL<\/code> \ub610\ub294 FLOAT<\/code> \ud0c0\uc785\uc774\uace0, \uc18c\uc218\uc810 \uc774\ud558\uc758 \uc815\ubc00\ub3c4\ub098 \uc804\uccb4 \uc22b\uc790\uc758 \ud06c\uae30\uac00 \uc5c5\ub370\uc774\ud2b8\ud558\ub824\ub294 \uac12\uc5d0 \ube44\ud574 \uc791\ub2e4\uba74, \uc774\ub7ec\ud55c \uacbd\uace0\uac00 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\ud574\uacb0 \ubc29\ubc95<\/h3>\n\n\n\n
    \n
  1. \ub370\uc774\ud130 \ud0c0\uc785 \ud655\uc778<\/strong>: \uba3c\uc800 buyPrice<\/code> \uc5f4\uc758 \ud604\uc7ac \ub370\uc774\ud130 \ud0c0\uc785\uacfc \uc815\ubc00\ub3c4\ub97c \ud655\uc778\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n\n\n
    <\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
       DESCRIBE products;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
    \uc774 \uba85\ub839\uc5b4\ub294 products<\/code> \ud14c\uc774\ube14\uc758 \ubaa8\ub4e0 \uc5f4\uacfc \uadf8 \ub370\uc774\ud130 \ud0c0\uc785\uc744 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4.<\/p>\n\n\n\n
      \n
    1. \ub370\uc774\ud130 \ud0c0\uc785 \ubcc0\uacbd<\/strong>: \ud544\uc694\ud55c \uacbd\uc6b0, \ub354 \ud070 \uac12\uc744 \uc800\uc7a5\ud560 \uc218 \uc788\ub3c4\ub85d buyPrice<\/code> \uc5f4\uc758 \ub370\uc774\ud130 \ud0c0\uc785\uc744 \ubcc0\uacbd\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, buyPrice<\/code> \uc5f4\uc774 DECIMAL(10,2)<\/code>\ub85c \uc124\uc815\ub418\uc5b4 \uc788\ub2e4\uba74, DECIMAL(12,2)<\/code>\uc640 \uac19\uc774 \uc815\ubc00\ub3c4\ub97c \ub192\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n\n\n
      <\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
         <\/span>ALTER<\/span> <\/span>TABLE<\/span> products <\/span>MODIFY<\/span> COLUMN buyPrice <\/span>DECIMAL<\/span>(<\/span>12<\/span>,<\/span>2<\/span>);<\/span><\/span>\n   <\/span>-- 0.99999999999999999999 \uc774\ub7f4\ub54c\ub294 9\uac1c\uc218 20\uac1c \ub9cc\ud07c decimal \ub4a4\uc5d0 \ub298\ub9ac\uae30,, DECIMAL(12,20);<\/span><\/span>\n   <\/span>-- \uacf1\uc148\uc774\ub098, \ub098\ub217\uc148\ud560\ub54c, 0. \ub4a4\uc5d0 \ucc98\ub9ac \uc798\ud574\uc57c\ud568. \uc790\ub3d9\uc73c\ub85c \uc9e4\ub77c\uc11c \uc800\uc7a5\ud558\uc9c0 \uc54a\uc74c.<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
        \n
      1. \uc5c5\ub370\uc774\ud2b8 \uc7ac\uc2e4\ud589<\/strong>: \ub370\uc774\ud130 \ud0c0\uc785\uc744 \uc870\uc815\ud55c \ud6c4, \uc5c5\ub370\uc774\ud2b8 \ucffc\ub9ac\ub97c \ub2e4\uc2dc \uc2e4\ud589\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n\n\n
        <\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
           <\/span>UPDATE<\/span> products<\/span><\/span>\n   <\/span>SET<\/span> buyPrice <\/span>=<\/span> buyPrice <\/span>*<\/span> <\/span>1<\/span>.<\/span>10<\/span><\/span>\n   <\/span>WHERE<\/span> productLine <\/span>=<\/span> <\/span>'<\/span>Classic Cars<\/span>'<\/span>;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
        \uc774\ub7ec\ud55c \ub2e8\uacc4\ub97c \ud1b5\ud574 buyPrice<\/code> \uc5f4\uc758 \uac12\uc744 \uc131\uacf5\uc801\uc73c\ub85c \uc5c5\ub370\uc774\ud2b8\ud560 \uc218 \uc788\uc73c\uba70, \ub370\uc774\ud130\uac00 \uc798\ub9b4 \uc704\ud5d8\uc744 \uc904\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130 \ud0c0\uc785 \ubcc0\uacbd\uc740 \uae30\uc874 \ub370\uc774\ud130\uc5d0 \uc601\ud5a5\uc744 \uc904 \uc218 \uc788\uc73c\ubbc0\ub85c, \uc791\uc5c5\uc744 \uc218\ud589\ud558\uae30 \uc804\uc5d0 \ub370\uc774\ud130 \ubc31\uc5c5\uc744 \uc218\ud589\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n
        <\/p>\n","protected":false},"excerpt":{"rendered":"
        sql UPDATE\ud560\ub54c Data truncated \uc5d0\ub7ec \ubc1c\uc0dd\uc2dc<\/p>\n","protected":false},"author":1,"featured_media":1716,"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":[161,117,162],"_links":{"self":[{"href":"https:\/\/dohokin.com\/index.php?rest_route=\/wp\/v2\/posts\/1714"}],"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=1714"}],"version-history":[{"count":1,"href":"https:\/\/dohokin.com\/index.php?rest_route=\/wp\/v2\/posts\/1714\/revisions"}],"predecessor-version":[{"id":1717,"href":"https:\/\/dohokin.com\/index.php?rest_route=\/wp\/v2\/posts\/1714\/revisions\/1717"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dohokin.com\/index.php?rest_route=\/wp\/v2\/media\/1716"}],"wp:attachment":[{"href":"https:\/\/dohokin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1714"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dohokin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1714"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dohokin.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1714"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}