{"id":1150,"date":"2012-12-03T08:47:39","date_gmt":"2012-12-03T08:47:39","guid":{"rendered":"http:\/\/brain.payzip.co.kr\/?p=1150"},"modified":"2012-12-03T08:47:39","modified_gmt":"2012-12-03T08:47:39","slug":"mysql%ec%97%90%ec%84%9c-%ec%a7%80%ec%9b%90%ed%95%98%eb%8a%94-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ed%98%95mysql-datatypes","status":"publish","type":"post","link":"https:\/\/blog.goorigo.com\/?p=1150","title":{"rendered":"MySQL\uc5d0\uc11c \uc9c0\uc6d0\ud558\ub294 \ub370\uc774\ud130 \ud615(MySQL DataTypes)"},"content":{"rendered":"

\ucd9c\ucc98 :http:\/\/www.lovelgw.com\/Blog\/211<\/a><\/p>\n

\ub370\uc774\ud130 \ud0c0\uc785<\/strong>
\nMySQL \uc740 \ub2e4\uc591\ud55c \ub370\uc774\ud130 \ud0c0\uc785\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc544\ub798 \ud45c\ub97c \ubcf4\uc2dc\uba74 \ub370\uc774\ud130 \ud615 , \ubc94\uc704 \uadf8\ub9ac\uace0 \ub370\uc774\ud130 \ud06c\uae30\ub97c \ubcf4\uc2e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130 \ud0c0\uc785\uc740 \uc2e4\uc81c \uc785\ub825\ud558\ub294 \ub370\uc774\ud130 \ud615\uc5d0 \ub9de\ucd94\uc5b4\uc11c \ucd5c\uc18c\ud55c\uc758 \ud06c\uae30\ub85c \uc7a1\uc544 \uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4. \uc544\ub798 \ud45c\ub97c \ubcf4\uc2dc\uba74 \ub370\uc774\ud130 \ud615\uacfc \uadf8 \uac12\uc758 \ubc94\uc704 \uadf8\ub9ac\uace0 \ud06c\uae30\uc5d0 \ub300\ud574\uc11c \ubcf4\uc2e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

MySQL\uc5d0\uc11c \uc9c0\uc6d0\ud558\ub294 \ub370\uc774\ud130\u00a0\ud615(MySQL DataTypes)
\n<\/strong><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\ud615\ud0dc<\/th>\n\ub370\uc774\ud130\ud615<\/th>\n\ubc94\uc704<\/th>\n\ud06c\uae30<\/th>\n<\/tr>\n<\/thead>\n
\uc22b\uc790\ud615<\/td>\nTINYINT<\/td>\n-128 ~ 128 , 0 ~ 255<\/td>\n1 Byte<\/td>\n<\/tr>\n
SMALLINT<\/td>\n-32768 ~ 32767 , 0 ~ 65535<\/td>\n2 Byte<\/td>\n<\/tr>\n
MEDIUMINT<\/td>\n-8388608 ~ 8388607, 0 ~ 16777215<\/td>\n3 Byte<\/td>\n<\/tr>\n
INT, INTEGER<\/td>\n-2147483648 ~ 2147483647, 0 ~ 4294967295<\/td>\n4 Byte<\/td>\n<\/tr>\n
BIGINT<\/td>\n-9223372036854775808 ~ 9223372036854775807
\n0 ~ 18446744073709551615<\/td>\n		8 Byte<\/td>\n<\/tr>\n
FLOAT<\/td>\n-3.402823466E+38 ~ -1.175494351E-38
\n1.175494351E-38 ~ 3.402823466E+38<\/td>\n		4 Byte<\/td>\n<\/tr>\n
DOUBLE [PRECISION], REAL<\/td>\n1.7976931348623157E+308 ~ -2.2250738585072014E-308
\n0 ~ 2.2250738585072014E-308<\/td>\n		8 Byte<\/td>\n<\/tr>\n
DECIMAL(M,D), NUMERIC(M,D)<\/td>\n\ub370\uc774\ud130 \ubca0\uc774\uc2a4 \uc124\uc815 \ubc0f \uc2dc\uc2a4\ud15c\uc5d0 \ub530\ub77c \ub2e4\ub984<\/td>\n\uac00\ubcc0\uc801 \ud06c\uae30<\/td>\n<\/tr>\n
\ub0a0\uc790\ud615<\/td>\nDATE<\/td>\n\u20191000-01-01\u2032 ~ \u20199999-12-31\u2032<\/td>\n3 Byte<\/td>\n<\/tr>\n
TIME<\/td>\n\u2018-838:59:59\u2032 ~ \u2019838:59:59\u2032<\/td>\n3 Byte<\/td>\n<\/tr>\n
DATETIME<\/td>\n\u20191000-01-01 00:00:00\u2032 ~ \u20199999-12-31 23:59:59\u2032<\/td>\n8 Byte<\/td>\n<\/tr>\n
TIMESTAMP<\/td>\n\u20191970-01-01 00:00:01\u2032 ~ \u20192038-01-19 03:14:07\u2032<\/td>\n4 Byte<\/td>\n<\/tr>\n
YEAR<\/td>\n1901 ~ 2155<\/td>\n1 Byte<\/td>\n<\/tr>\n
\ubb38\uc790(\uc5f4)\ud615<\/td>\nCHAR(M)<\/td>\n1~ 255 \uac1c\uc758 \ubb38\uc790<\/td>\nM <= 255 Byte<\/td>\n<\/tr>\n
BINARY(M)<\/td>\n1 ~ 255 \uac1c\uc758 \ubb38\uc790<\/td>\nM Byte<\/td>\n<\/tr>\n
VARCHAR(M), VARBINARY(M)<\/td>\n1 ~ 255 \uac1c\uc758 \ubb38\uc790<\/td>\nM Byte<\/td>\n<\/tr>\n
TINYBLOB, TINYTEXT<\/td>\n\ucd5c\ub300 2^8<\/td>\n\uc785\ub825\ub41c \uae38\uc774 \ub9cc\ud07c<\/td>\n<\/tr>\n
BLOB, TEXT<\/td>\n\ucd5c\ub300 2^16<\/td>\n\uc785\ub825\ub41c \uae38\uc774 \ub9cc\ud07c<\/td>\n<\/tr>\n
MEDIUMBLOB, MEDIUMTEXT<\/td>\n\ucd5c\ub300 2^24<\/td>\n\uc785\ub825\ub41c \uae38\uc774 \ub9cc\ud07c<\/td>\n<\/tr>\n
LONGBLOB, LONGTEXT<\/td>\n\ucd5c\ub300 2^32<\/td>\n\uc785\ub825\ub41c \uae38\uc774 \ub9cc\ud07c<\/td>\n<\/tr>\n
ENUM<\/td>\n\ucd5c\ub300 65525 \uac1c<\/td>\n1 ~ 2 Byte<\/td>\n<\/tr>\n
SET<\/td>\n\ucd5c\ub300 64 \uac1c\uc758 \uc14b<\/td>\n1 ~ 8 Byte<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\ud14c\uc774\ube14\uc744 \uc124\uacc4 \uc2dc\uc5d0 \ub370\uc774\ud130\uc5d0 \ub9de\ub294 \ub370\uc774\ud130 \ub97c \uc120\uc815\ud574\uc8fc\ub294\uac83\uc774 \ub9e4\uc6b0 \uc911\uc694\ud569\ub2c8\ub2e4.<\/strong>?\ubb3c\ub860 \ud070 \ub370\uc774\ud130 \ud615\uc73c\ub85c \uc7a1\uc544\ub3c4 \ubb38\uc81c\ub294 \uc5c6\uc9c0\ub9cc \ub370\uc774\ud130\uc758 \ud6a8\uc728\uc131\uc5d0\uc11c \ub9ce\uc740 \uc131\ub2a5 \uc800\ud558\uac00 \uc788\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\uc608\ub97c \ub4e4\uc5b4 \ud604\uc7ac \ud559\uad50 \ud559\uc0dd\uc218\ub97c \ub2e4\ub8e8\ub294 \ud14c\uc774\ube14\uc774 \uc788\ub2e4\uace0 \uac00\uc815\ud569\uc2dc\ub2e4. (\uc878\uc5c5, \uc785\ud559 \uc608\uc815, \uae30\ud0c0 \ud559\uc0dd\uc740 \uc81c\uc678 \uc2dc\ud0a8 \uc7ac\ud559\uc911\uc778 \ud559\uc0dd) \ud559\uc0dd\ub4e4\uc774 \ub9ce\uc544\uc57c \ucd5c\ub300 65535 \uba85\uc740 \uc548\ub418\uace0 255\uba85\uc740 \ub118\uc744 \uac83\uc785\ub2c8\ub2e4. \uadf8\ub7fc PRIMARY KEY\ub85c \uc7a1\uc744 \ud0a4 \uac12\uc740 SMALLINT \ud615\uc758 \ub370\uc774\ud130 \ud615\uc73c\ub85c \ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n

\ub610 \ud55c\uac00\uc9c0 \uc608\ub97c \ub4e4\uba74 \ucee4\ubba4\ub2c8\ud2f0 \ud3ec\ud138 \uc0ac\uc774\ud2b8\uc758 \ud68c\uc6d0\uc774\ub77c\uace0 \uc0dd\uac01\uc744 \ud574\ubd05\uc2dc\ub2e4 (\uad6d\ub0b4 \ud68c\uc6d0\ub9cc \ubc1b\uc744, \uc911\ubcf5, \ud0c8\ud1f4 \uae30\ud0c0 \uc608\uc678 \ube44 \ud3ec\ud568) \uadf8\ub7ec\uba74 \uc804\uad6d\ubbfc\uc774 \uac00\uc785\ud574\ub3c4 5\ucc9c\ub9cc\uba85\uc785\ub2c8\ub2e4. \uadf8\ub7fc \uc5b4\ub5a4 \ub370\uc774\ud130 \ud615\uc774 \ub9de\uc744 \uae4c\uc694? INT\ud615\uc73c\ub85c \uc7a1\uc2b5\ub2c8\ub2e4.<\/p>\n

\uc704 \uc608\ucc98\ub7fc \ub370\uc774\ud130\uc5d0 \uac00\uc7a5 \ud6a8\uc728\uc801\uc778 \ubc29\ubc95\uc73c\ub85c \ub370\uc774\ud130 \ud615\uc744 \uc124\uc815\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n

NULL \uc744 \ucd5c\ub300\ud55c \ubc30\uc81c \ud569\ub2c8\ub2e4.<\/strong>?\ud14c\uc774\ube14 \uc124\uacc4\uc2dc NOT NULL \uc774 \uc544\ub2cc NULL\uc744 \ud5c8\uc6a9\ud558\uac8c \ub418\uba74 \ud574\ub2f9 \ud544\ub4dc\uac00 NULL \uc778\uc9c0\ub97c \uad6c\ubd84\ud560\uc218 \uc788\uac8c \ud558\ub294 \ud50c\ub798\uadf8\ub97c \uc704\ud55c \uacf5\uac04\uc774 \ub530\ub85c \ud544\uc694\ud558\uace0 , \ub370\uc774\ud130\ub97c \uc81c\uc5b4 \ud560\ub54c NULL\uc778\uc9c0\ub97c \ud55c\ubc88\ub354 \ud655\uc778\ud558\uac8c \ub429\ub2c8\ub2e4. (NULL\uacfc \u201c\u201d\ub294 \ub2e4\ub985\ub2c8\ub2e4.)<\/p>\n

ROW_FORMAT \uc774 \uac00\ubcc0\uc801\uc778 \uac83 \ubcf4\ub2e4\ub294 FIXED \uc778\uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4<\/strong>. \ucd5c\ub300\ud55c \uae30\uc900\uc774 \ub418\ub294 \ud14c\uc774\ube14\uc77c \uacbd\uc6b0\uc5d0\ub294 FIXED \ub85c \uc0ac\uc6a9\ud558\uace0 \uadf8\uc678 \uac00\ubcc0\uc801\uc778 \uc694\uc18c (TEXT, BLOB, VARCHAR)\ub4f1\uc740 \ub530\ub85c \ud14c\uc774\ube14\uc744 \ub5bc\uc5b4 \ub193\uc73c\uc138\uc694. \uc131\ub2a5\uc774 \ub9ce\uc774 \ud5a5\uc0c1\ub429\ub2c8\ub2e4.?information_schema<\/strong>?\ub370\uc774\ud130 \ubca0\uc774\uc2a4\uc758?TABLES<\/strong>?\ud14c\uc774\ube14\uc5d0\uc11c \ud655\uc778 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

MySQL \uc740 PRIMARY KEY\uac00 AUTO_INCREMENT \uc5d0 \ucd5c\uc801\ud654 \ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \ucd5c\ub300\ud55c AUTO_INCREMENT\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud6a8\uc728\uc801\uc73c\ub85c PRIMARY KEY\ub97c \uc0ac\uc6a9\ud558\uc138\uc694<\/p>\n

\ubaa8\ub4e0 \ub370\uc774\ud130 \uc124\uacc4\ub294 \uc815\uaddc\ud654 \ud6c4 \uc124\uacc4\ub97c \ud558\uc138\uc694<\/strong>?MySQL Workbench<\/strong>?\ub97c \uc774\uc6a9\ud558\uba74 \uc815\uaddc\ud654 \uc791\uc5c5\uc5d0 \ub9ce\uc774 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4.(\uba38\ub9ac \uc18d\uc5d0 \uc788\ub294\uac83 \ubcf4\ub2e4\ub294 \ub208\uc73c\ub85c \ubcf4\uace0 \uadf8\ub824\ubcf4\ub294\uac8c \uc88b\uaca0\uc8e0~) \ub370\uc774\ud130 \uc124\uacc4\ub294 \ub3c4\uc2dd\ud654 \ud55c \ud6c4\uc5d0 \ud56d\uc0c1 \uc7ac \uac80\ud1a0 \ud558\uc138\uc694~ \uc548\ubcf4\uc774\ub294\uac83\ub3c4 \ubcf4\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\ubb34\ub9ac\ud558\uac8c \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud558\uc9c0 \ub9c8\uc138\uc694<\/strong>?. WHERE \uc5d0 \uc4f0\uc778\ub2e4\uace0 \ud574\uc11c \ubaa8\ub4e0\uac83\uc744 \uc778\ub371\uc2a4 \ud560 \ud544\uc694\ub294 \uc5c6\uc2b5\ub2c8\ub2e4. \ucd5c\ub300\ud55c \ud544\uc694\ud558\uace0 \uac00\uc7a5 \uac04\ub2e8\ud558\uac8c \ubc94\uc704\ub97c \uc7a1\uc544\uc11c \uc0ac\uc6a9\uc744 \ud558\uc138\uc694, \ubb34\ub9ac\ud55c \uc778\ub371\uc2a4\ub294 \uc804\uccb4\uc801\uc778 INSERT \/ UPDATE \uc131\ub2a5\uc744 \ub5a8\uc5b4 \ub728\ub9b4 \uc218 \uc788\uc2b5\ub2c8\ub2e4. ANALYZE TABLE \uacfc OPTIMIZE TABLE \ub85c \uc8fc\uae30\uc801\uc73c\ub85c \ub370\uc774\ud130 \ub2e8\ud3b8\ud654\ub97c \uc81c\uac70\ud574\uc8fc\uc138\uc694. 2\uac1c \uc774\uc0c1\uc758 \uc870\uac74\uc774 \ud544\uc218\uc801\uc73c\ub85c \uac80\uc0c9\uc5d0 \uc774\uc6a9\uc774 \ub41c\ub2e4\uba74 \ubcf5\ud569 \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud558\uc138\uc694 . \ub450 \uac1c\uc758 \ud544\ub4dc\uac00 \uc778\ub371\uc2a4\uac00 \ub530\ub85c \ub530\ub85c \uc7a1\ud600 \uc788\ub294\uac83 \ubcf4\ub2e4 \ub354\uc6b1 \ube60\ub974\uac8c \uacb0\uacfc\ub97c \ubcf4\uc5ec\uc90d\ub2c8\ub2e4.<\/p>\n

\ud6a8\uc728\uc801\uc778 \ud14c\uc774\ube14 \uc124\uacc4 \ubc29\ubc95 \uc694\uc57d<\/strong>?<\/strong>
\n1. \uc800\uc7a5\ud560 \ub370\uc774\ud130\uc5d0 \ub9de\uac8c \ucd5c\ub300\ud55c \uc791\uc740 \ub370\uc774\ud130 \ud0c0\uc785\uc744 \uc0ac\uc6a9\ud574\uc57c \ud569\ub2c8\ub2e4.
\n2. \uceec\ub7fc\uc5d0\uc11c DEFAULT NULL\uc744 \ucd5c\ub300\ud55c \ud5c8\uc6a9\ud558\uc9c0 \ub9c8\uc138\uc694
\n3. \uac00\ubcc0\uc801\uc778 \ub370\uc774\ud130\ud0c0\uc785 \ubcf4\ub2e4 \uace0\uc815\ud615\uc758 \ub370\uc774\ud130 \ud0c0\uc785\uc744 \uc120\ud0dd\ud558\uc138\uc694
\n4. PRIMARY KEY\ub294 \uc791\uc740 \ub370\uc774\ud130\ud615\uc73c\ub85c \uc7a1\uc2b5\ub2c8\ub2e4. (AUTO_INCREMENT \ucd5c\ub300\ud55c \uc0ac\uc6a9)
\n5. \ubaa8\ub4e0 \ub370\uc774\ud130\ub294 \uc815\uaddc\ud654\ub97c \uaf2d \ud574\uc57c \ud569\ub2c8\ub2e4. (\uc815\uaddc\ud654\ubc29\ubc95 \ucc38\uc870<\/a>)
\n6. \uc778\ub371\uc2a4\ub294 \ud544\uc694\ud55c \uacbd\uc6b0\ub9cc \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/strong><\/p>\n

\uc804\uccb4\uc801\uc778 \ud14c\uc774\ube14 \uc124\uacc4\uc5d0 \ub300\ud55c \uc694\uc57d\uc774\uc5c8\uc2b5\ub2c8\ub2e4. \ud14c\uc774\ube14\uc744 \uc124\uacc4 \ud560\ub54c \ub370\uc774\ud130 \ud615\uc5d0 \uc54c \ub9de\ub294 \ud615\ud0dc\uc758 \ub370\uc774\ud130 \ud615\uc744 \uc120\ud0dd\uc744 \ud574\uc11c \ud6a8\uc728\uc801\uc73c\ub85c \uc124\uacc4\ub97c \ud574\ubcf4\uc138\uc694 ^^<\/p>\n","protected":false},"excerpt":{"rendered":"

\ucd9c\ucc98 :http:\/\/www.lovelgw.com\/Blog\/211 \ub370\uc774\ud130 \ud0c0\uc785 MySQL \uc740 \ub2e4\uc591\ud55c \ub370\uc774\ud130 \ud0c0\uc785\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc544\ub798 \ud45c\ub97c \ubcf4\uc2dc\uba74 \ub370\uc774\ud130 \ud615 , \ubc94\uc704 \uadf8\ub9ac\uace0 \ub370\uc774\ud130 \ud06c\uae30\ub97c \ubcf4\uc2e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130 \ud0c0\uc785\uc740 \uc2e4\uc81c \uc785\ub825\ud558\ub294 \ub370\uc774\ud130 \ud615\uc5d0 \ub9de\ucd94\uc5b4\uc11c… <\/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\/1150"}],"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=1150"}],"version-history":[{"count":0,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts\/1150\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1150"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1150"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1150"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}