{"id":1412,"date":"2013-11-24T19:55:12","date_gmt":"2013-11-24T19:55:12","guid":{"rendered":"http:\/\/brain.payzip.co.kr\/?p=1412"},"modified":"2013-11-24T19:55:12","modified_gmt":"2013-11-24T19:55:12","slug":"mysql-int11-%ec%97%90%ec%84%9c%ec%9d%98-11%ec%9d%98-%ec%9d%98%eb%af%b8%eb%a5%bc-%ec%95%84%ec%84%b8%ec%9a%94","status":"publish","type":"post","link":"https:\/\/blog.goorigo.com\/?p=1412","title":{"rendered":"[MySQL] INT(11) \uc5d0\uc11c\uc758 (11)\uc758 \uc758\ubbf8\ub97c \uc544\uc138\uc694?"},"content":{"rendered":"

\ud760… \ucc29\uac01\uc5d0 \ube60\uc9c8\uc218 \uc788\ub294 \uc704\ud5d8\uc774 \uc788\uad70;; \uacb0\uad6d \uc81c\ub85c\ud544\uc744 \uba87\uc790\ub9ac\ub85c \ud560\uac74\uc9c0;;<\/p>\n

<< \uc608\uc81c >><\/strong>
\n##################################################################################################
\n# 1. \ud14c\uc2a4\ud2b8 \ud14c\uc774\ube14 \uc0dd\uc131<\/span>
\nCREATE<\/span>\u00a0TABLE int_test (
\nint_1\u00a0INT<\/span>(1),
\nint_1_z\u00a0INT<\/span>(1)\u00a0ZEROFILL<\/span>,
\nint_5\u00a0INT<\/span>(5),
\nint_5_z\u00a0INT<\/span>(5)\u00a0ZEROFILL<\/span>,
\nint_9\u00a0INT<\/span>(9),
\nint_9_z\u00a0INT<\/span>(9)\u00a0ZEROFILL<\/span>,
\nint_11\u00a0INT<\/span>(11),
\nint_11_z\u00a0INT<\/span>(11)\u00a0ZEROFILL<\/span>
\n)ENGINE=INNODB DEFAULT CHAR SET =UTF8<\/span>;<\/p>\n

# —————————————————————————<\/span><\/span><\/p>\n

# 2. \ud14c\uc2a4\ud2b8 \uac12 \ub123\uc5b4\ubcf4\uae30
\nINSERT<\/span>\u00a0INTO<\/span>\u00a0int_test\u00a0VALUES<\/span>(1,1,1,1,1,1,1,1);
\nINSERT INTO<\/span>\u00a0int_test\u00a0VALUES<\/span>(12345,12345,12345,12345,12345,12345,12345,12345);
\nINSERT INTO\u00a0<\/span>int_testVALUES<\/span>(1234567890,1234567890,1234567890,1234567890,1234567890,1234567890,1234567890,1234567890);
\n##################################################################################################<\/span>
\n<\/span>
\n\ub2f9\uc2e0\uc758 \ud3c9\uc18c \uc0dd\uac01\ub300\ub85c\ub77c\uba74,
\n#\u00a0<\/span>——————————<\/span><\/span>
\nSELECT<\/span>\u00a0*
\nFROM<\/span>\u00a0int_test;
\n# ——————————<\/span>
\n\uc758 \uacb0\uacfc\ub294?<\/p>\n

<< \uc218\ud589 \uacb0\uacfc >><\/span><\/strong><\/p>\n\n\n\n
\u00a0mysql> SELECT * FROM int_test;
\n+————+————+————+————+————+————+————+————-+
\n| int_1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | int_1_z\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | int_5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0| int_5_z\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0| int_9\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | int_9_z\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | int_11\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | int_11_z\u00a0\u00a0\u00a0\u00a0 \u00a0 |
\n+————+————+————+————+————+————+————+————-+
\n|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 1 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a01 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 1 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 00001 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0 1 |\u00a0 \u00a0000000001 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0 1 | 00000000001 |
\n|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a012345 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 12345 |\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 12345 |\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0 12345 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a012345 |\u00a0 \u00a0000012345 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 12345 | 00000012345 |
\n|\u00a0\u00a0 1234567890 | 1234567890 |\u00a0\u00a0 1234567890 |\u00a0\u00a01234567890 | 1234567890 |\u00a0 1234567890 |\u00a0 \u00a01234567890 | 01234567890 |
\n+————+————+————+————+————+————+————+————-+
\n3 rows in set (0.00 sec)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\uc5bc\ub798? \uc774\uac70… \ub2f9\uc2e0\uc774 \uc608\uc0c1\ud558\ub358 \uac12\uacfc\ub294 \ub2e4\ub974\uc9c0 \uc544\ub2c8\ud55c\uac00?<\/p>\n

\ubd84\uba85\ud788 INT(n)\ud558\uba74\u00a0 n\uac1c\ub9cc \uc785\ub825\ub420 \uac83\uc774\ub77c \uc0dd\uac01\ud588\uc5c8\ub294\ub370,
\n\uac12\uc774 \ubabd\ub545 \ub4e4\uc5b4\uac00\ubc84\ub9ac\ub124???<\/p>\n

http:\/\/dev.mysql.com\/doc\/refman\/5.0\/en\/numeric-types.html<\/span><\/a>
\n\ub97c \ubcf4\uba74, \uc774\uc5d0 \ub300\ud55c \uba85\ud655\ud55c \uc124\uba85\uc774 \uc788\ub2e4..<\/p>\n

\uc9e7\uc740 \uc789\uae00\ub9ac\uc26c \uc2e4\ub825\uc73c\ub85c \uc694\uc57d\ud574 \ubcf4\uc790\uba74,<\/p>\n

INT\uc758 \uad04\ud638\ub294 \ubcf4\uc5ec\uc9c0\ub294 \uc22b\uc790\uc758 \uac1c\uc218\uc758 \uc81c\uc57d\uc744 \uc758\ubbf8\ud558\ub294 \uac83\uc774 \uc544\ub2c8\ub2e4.
\n\uc544\ubb34\ub9ac INT \uc606\uc5d0 \uad04\ud638\uce58\uace0 \uc22b\uc790\ub97c \ub123\uc5b4\ubd10\ub77c, \ub4e4\uc5b4\uac08 \uc218 \uc788\ub294 \ud55c\uacc4\ub294 \uc5b8\uc81c\ub098 \uac19\uc744 \uaec4? \u314b\u314b\u314b (\uc758\uc5ed -0-;;)
\nINT\uc758 \uad04\ud638 \uc635\uc158\uc740 ZEROFILL\uc744 \uc704\ud55c \uac70\ub2e4.<\/strong><\/span>
\n\ub9cc\uc57d \uad04\ud638 \uc548\uc5d0 5\ub97c \uc9d1\uc5b4\ub123\uc5c8\ub2e4\uba74(INT(5)),\u00a05\uc790\ub9ac \ub0b4\uc758 \uc22b\uc790\ub294 0\uc73c\ub85c \ucc44\uc6cc\uc9c0\uac8c \ub41c\ub2e4.<\/span><\/span>
\n\uc3fc\ub77c\uc3fc\ub77c….<\/span>
\n<\/span>
\n\uac1c\ubfd4.. \uc774\ub118\uc758 \uc9e7\uc740 \uc601\uc5b4… \uc601\uc5b4 \ub54c\ubb38\uc5d0 \uc18d\uc774 \uc6b8\ub801\uac70\ub9b0\ub2f9 (-\u3160-);;<\/p>\n

\uc694\uc57d\ud558\uc790\uba74,
\nINT\uc758 \uad04\ud638 \uc635\uc158 \uae30\ub2a5\uc740 ZEROFILL\uc5d0\uc11c 0\uc774 \ucc44\uc6cc\uc9c0\uac8c \ub418\ub294 \uac1c\uc218\uc774\uace0,
\n\uc2e4\uc81c \uc800\uc7a5\uacf5\uac04 \ubc0f \uc785\ub825 \uac00\ub2a5 \ud55c\uacc4\ub294 \ub3d9\uc77c\ud558\ub2e4\ub294 \uc758\ubbf8\uc774\ub2e4.<\/span><\/strong><\/p>\n

\uc704 \uc2e4\ud589\uacb0\uacfc\uc5d0\uc11c\ub3c4 \ubcfc \uc218 \uc788\ub4ef\uc774,
\nINT(1), INT(5), INT(9), INT(11)\uc5d0 \ub4e4\uc5b4\uac00\ub294 \uac12\uc740 \ub3d9\uc77c\ud558\uba70,
\nINT(1) ZEROFILL, INT(5) ZEROFILL, INT(9) ZEROFILL, INT(11) ZEROFILL \uc5d0\uc11c\ub9cc,
\n0\uc774 \ub4e4\uc5b4\uac00\ub294 \uac1c\uc218\uc5d0 \ucc28\uc774\uac00 \uc788\uc74c\uc744 \ubcfc \uc218 \uc788\ub2e4.<\/p>\n

\uadf8\ub098\ub9c8 ZEROFILL\uc758 \ud55c\uacc4\ub97c \ub118\uc5b4\ubc84\ub9ac\uba74, \uadf8 \ub54c\ubd80\ud134 \uad6c\ubd84\ub3c4 \uc548 \uac04\ub2e4 -0-;;;;;<\/p>\n

\uc790, \uc815\ub9ac\ud558\uc790!!<\/p>\n

\uc55e\uc73c\ub85c INT(n) \uc5d0\uc11c n\uc774 \uc790\uae30 \ub9d8\ub300\ub85c \ub4e4\uc5b4\uac00 \uc788\ub2e4\uace0 \uc560\uafce\uc740 \uc0ac\ub78c \uc7a1\uc9c0\ub9d0\uace0,
\n‘\ud48b! ZEROFILL\uc744 \uc704\ud55c \uacf5\uac04\uc774\uad70! \ucbe7\ucbe7\ucbe7…’
\n<\/strong><\/span>\ud558\uba74\uc11c \uc544\ub294\uccb4 \ud574\uc8fc\ub294 \uc388\uc4f0\ub97c \ubcf4\uc5ec\ub77c!!!<\/span><\/p>\n

\uadf8\ub7fc, \ub2f9\uc2e0\uc740 \uc704\ub300\ud55c \uc778\ubb3c\ub85c \ucd94\uc559\ubc1b\uace0 \uc874\uacbd\ubc1b\uc73c\ub9ac~~~ ……… \ub294 \uc544\ub2c8\uaca0\uc9d5 -0-;;;;<\/p>\n

\uc774\uc0c1!<\/p>\n

[2009-01-09] \ub367\uae00\uc5d0 \ub300\ud55c \uc124\uba85\uc744 \uc704\ud574 \uc544\ub798\uc640 \uac19\uc774 \ucd94\uac00\ud569\ub2c8\ub2e4 ^0^\/<\/strong><\/span><\/p>\n

\uacb0\ub860\ubd80\ud130 \ub9d0\uc500\ub4dc\ub9ac\uc790\uba74, \uc624\ub77c\ud074\uc5d0\uc11c\ub294 \uc2e4\uc81c \uc790\ub9ac\uc218\ub97c \ud45c\ud604\ud558\ub294\ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. ^^
\n\uc544\ub798 \uc608\uc81c\ub97c \ubcfc\uae4c\uc694?<\/p>\n

<< \uc608\uc81c >>
\n<\/strong>##################################################################################################
\n# 1. \ud14c\uc2a4\ud2b8 \ud14c\uc774\ube14 \uc0dd\uc131
\n<\/span>CREATE TABLE\u00a0<\/span>number_test (
\nNUMBER_2 NUMBER(2),
\nNUMBER_5 NUMBER(5)
\n);
\n# —————————————————————————<\/span><\/span><\/p>\n

# 2. \ud14c\uc2a4\ud2b8 \uac12 \ub123\uc5b4\ubcf4\uae30
\nINSERT<\/span>\u00a0INTO<\/span>\u00a0number_test\u00a0VALUES<\/span>(12,12);
\nINSERT INTO<\/span>\u00a0number_test\u00a0VALUES<\/span>(12345,12345);
\n##################################################################################################<\/span>
\n<\/span>
\n\uc758 \uacb0\uacfc\ub294?<\/p>\n

<< \uc218\ud589 \uacb0\uacfc >><\/span><\/strong><\/p>\n\n\n\n
SQL> INSERT INTO number_test VALUES(12,12);<\/span>1 \uac1c\uc758 \ud589\uc774 \ub9cc\ub4e4\uc5b4\uc84c\uc2b5\ub2c8\ub2e4.<\/span>SQL> INSERT INTO number_test VALUES(12345,12345);
\nINSERT INTO number_test VALUES(12345,12345)
\n*
\n1<\/span>\ud589\uc5d0 \uc624\ub958:
\nORA-01438: \uc774 \uc5f4\uc5d0 \ub300\ud574 \uc9c0\uc815\ub41c \uc804\uccb4 \uc790\ub9bf\uc218\ubcf4\ub2e4 \ud070 \uac12\uc774 \ud5c8\uc6a9\ub429\ub2c8\ub2e4.<\/span>
\nSQL> SELECT * FROM number_test;<\/span><\/p>\n

\u00a0 NUMBER_2\u00a0\u00a0 NUMBER_5
\n———- ———-
\n12\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 12<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\ucc38\uace0\uac00 \ub418\uc168\uc73c\uba74 \ud569\ub2c8\ub2e4. ^^<\/p>\n

\ucd9c\ucc98 :\u00a0http:\/\/blackbull.tistory.com\/44<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

\ud760… \ucc29\uac01\uc5d0 \ube60\uc9c8\uc218 \uc788\ub294 \uc704\ud5d8\uc774 \uc788\uad70;; \uacb0\uad6d \uc81c\ub85c\ud544\uc744 \uba87\uc790\ub9ac\ub85c \ud560\uac74\uc9c0;; << \uc608\uc81c >> ################################################################################################## # 1. \ud14c\uc2a4\ud2b8 \ud14c\uc774\ube14 \uc0dd\uc131 CREATE\u00a0TABLE int_test ( int_1\u00a0INT(1), int_1_z\u00a0INT(1)\u00a0ZEROFILL, int_5\u00a0INT(5), int_5_z\u00a0INT(5)\u00a0ZEROFILL, int_9\u00a0INT(9), int_9_z\u00a0INT(9)\u00a0ZEROFILL, int_11\u00a0INT(11), int_11_z\u00a0INT(11)\u00a0ZEROFILL… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts\/1412"}],"collection":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1412"}],"version-history":[{"count":0,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts\/1412\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1412"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1412"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1412"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}