{"id":1672,"date":"2015-08-27T21:53:34","date_gmt":"2015-08-27T12:53:34","guid":{"rendered":"http:\/\/w3devlabs.net\/wp\/?p=1672"},"modified":"2015-08-27T21:53:34","modified_gmt":"2015-08-27T12:53:34","slug":"mysql-%eb%8d%b0%ec%9d%b4%ed%84%b0%ed%98%95-%eb%b0%8f-%ed%81%ac%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/w3devlabs.net\/wp\/?p=1672","title":{"rendered":"MySQL \ub370\uc774\ud130\ud615 \ubc0f \ud06c\uae30"},"content":{"rendered":"<p>TINYINT[(M)] [UNSIGNED] [ZEROFILL]<br \/>\n\u2013 \ubc94\uc704 : -128 \uc5d0\uc11c 127 (UNSIGNED \uc77c \uacbd\uc6b0 0 \uc5d0 255)<\/p>\n<p>SMALLINT[(M)] [UNSIGNED] [ZEROFILL]<br \/>\n\u2013 \ubc94\uc704 : -32768 \uc5d0\uc11c 32767 (UNSIGNED \uc77c \uacbd\uc6b0 0 \uc5d0 65535)<\/p>\n<p>MEDIUMINT[(M)] [UNSIGNED] [ZEROFILL]<br \/>\n\u2013 \ubc94\uc704 : -8388608 \uc5d0\uc11c 8388607 (UNSIGNED \uc77c \uacbd\uc6b0 0 \uc5d0 16777215)<\/p>\n<p>INT[(M)] [UNSIGNED] [ZEROFILL]<br \/>\n\u2013 \ubc94\uc704 : -2147483648 \uc5d0\uc11c 2147483647 (UNSIGNED \uc77c \uacbd\uc6b0 0 \uc5d0 4294967295)<br \/>\n\u2013 \uc8fc\uc758 : \ubaa8\ub4e0 \uc5f0\uc0b0\uc740 \u201csigned BIGINT\u201d \ub85c \uc774\ub8e8\uc5b4\uc9c4\ub2e4. \ub530\ub77c\uc11c \ub354\ud558\uae30 \uacf1\ud558\uae30 \ub4f1\uc73c\ub85c \u201csigned BIGINT\u201d \uc758 \ubc94\uc704\ub97c \ubc97\uc5b4\ub09c\ub2e4\uba74 \uac12\uc774 \ud2c0\ub824\uc9c8 \uac83\uc774\ub2e4.<\/p>\n<p>NTEGER[(M)] [UNSIGNED] [ZEROFILL]<br \/>\n\u2013 \ubc94\uc704 : INT \uc640 \ub3d9\uc77c<\/p>\n<p>BIGINT[(M)] [UNSIGNED] [ZEROFILL]<br \/>\n\u2013 \ubc94\uc704 : -9223372036854775808 \uc5d0\uc11c 9223372036854775807 (UNSIGNED \uc77c \uacbd\uc6b0 0 \uc5d0 18446744073709551615)<\/p>\n<p>FLOAT[(M,D)] [ZEROFILL]<br \/>\n\u2013 \ubc94\uc704 : -3.402823466E+38 \uc5d0\uc11c -1.175494351E-38, 0 \uadf8\ub9ac\uace0 1.175494351E-38 \uc5d0\uc11c 3.402823466E+38<br \/>\n\u2013 \uc8fc\uc758 : unsigned \ub97c \uc124\uc815\ud560\uc218 \uc5c6\ub2e4.<\/p>\n<p>DOUBLE[(M,D)] [ZEROFILL]<br \/>\n\u2013 \ubc94\uc704 : -1.7976931348623157E+308 \uc5d0\uc11c -2.2250738585072014E-308, 0 \uadf8\ub9ac\uace0 2.2250738585072014E-308 \uc5d0\uc11c 1.7976931348623157E+308<br \/>\n\u2013 \uc8fc\uc758 : unsigned \ub97c \uc124\uc815\ud560\uc218 \uc5c6\ub2e4.<\/p>\n<p>REAL[(M,D)] [ZEROFILL]<br \/>\n\u2013 \ubc94\uc704 : DOUBLE \uacfc \ub3d9\uc77c<\/p>\n<p>DATE<br \/>\n\u2013 \ubc94\uc704 : \u20181000-01-01\u2019 \uc5d0\uc11c \u20189999-12-31\u2019<br \/>\n\u2013 \uc8fc\uc758 : unsigned \ub97c \uc124\uc815\ud560\uc218 \uc5c6\ub2e4.<\/p>\n<p>DATETIME<br \/>\n\u2013 \ubc94\uc704 : \u20181000-01-01 00:00:00\u2019 \uc5d0\uc11c \u20189999-12-31 23:59:59\u2019<\/p>\n<p>TIMESTAMP[(M)]<br \/>\n\u2013 \ubc94\uc704 : \u20181970-01-01 00:00:00\u2019 \uc5d0\uc11c 2037<\/p>\n<p>CHAR(M) [BINARY]<br \/>\n\u2013 \ubc94\uc704 : 1 \uc5d0\uc11c 255 \uae00\uc790<br \/>\n\u2013 \uc8fc\uc758 : \uace0\uc815\uae38\uc774\ub85c \uae38\uc774\uac00 \uc791\uc740 \uac12\uc774 \uc785\ub825\ub418\uba74 \uc624\ub978\ucabd\uc5d0 \uc2a4\ud398\uc774\uc2a4\ub85c \ucc44\uc6cc\uc838\uc11c \uc785\ub825\ub41c\ub2e4. BINARY \ud0a4\uc6cc\ub4dc\uac00 \uc8fc\uc5b4\uc9c0\uc9c0 \uc54a\uc744 \uacbd\uc6b0 \ub300\uc18c\ubb38\uc790 \uad6c\ubd84\uc5c6\uc774 \uac80\uc0c9\ud55c\ub2e4.<\/p>\n<p>VARCHAR(M) [BINARY]<br \/>\n\u2013 \ubc94\uc704 : 1 \uc5d0\uc11c 255 \uae00\uc790<br \/>\n\u2013 \uc8fc\uc758 : BINARY \ud0a4\uc6cc\ub4dc\uac00 \uc8fc\uc5b4\uc9c0\uc9c0 \uc54a\uc744 \uacbd\uc6b0 \ub300\uc18c\ubb38\uc790 \uad6c\ubd84\uc5c6\uc774 \uac80\uc0c9\ud55c\ub2e4.<\/p>\n<p>TINYTEXT<br \/>\n\u2013 \ubc94\uc704 : \ucd5c\ub300 255 \uae00\uc790<\/p>\n<p>TEXT<br \/>\n\u2013 \ubc94\uc704 : \ucd5c\ub300 65535 \uae00\uc790<\/p>\n<p>MEDIUMTEXT<br \/>\n\u2013 \ubc94\uc704 : \ucd5c\ub300 16777215 \uae00\uc790<\/p>\n<p>LONGTEXT<br \/>\n\u2013 \ubc94\uc704 : \ucd5c\ub300 4294967295 \uae00\uc790<\/p>\n<p>ENUM(\u2018value1\u2032,\u2019value2\u2019,\u2026)<br \/>\n\u2013 \ubc94\uc704 : \u2018value1\u2019, \u2018value2\u2019, \u2026, or NULL \ub9cc\uc774 \uc785\ub825\uac00\ub2a5\ud558\ub2e4. \ucd5c\ub300 65535 \uac1c\uc758 \ub2e4\ub978 \uac12\uc774 \ub4e4\uc5b4\uac08\uc218 \uc788\ub2e4.<\/p>\n<p>SET(\u2018value1\u2032,\u2019value2\u2019,\u2026)<br \/>\n\u2013 \ubc94\uc704 : \u2018value1\u2019, \u2018value2\u2019, \u2026, or NULL \ub9cc\uc774 \uc785\ub825\uac00\ub2a5\ud558\ub2e4. \ucd5c\ub300 64 \uac1c\uc758 \ub2e4\ub978 \uac12\uc774 \ub4e4\uc5b4\uac08\uc218 \uc788\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>\ucd9c\ucc98 :\u00a0http:\/\/blog.lael.be\/post\/115<\/p>\n","protected":false},"excerpt":{"rendered":"<p>TINYINT[(M)] [UNSIGNED] [ZEROFILL] \u2013 \ubc94\uc704 : -128 \uc5d0\uc11c 127 (UNSIGNED \uc77c \uacbd\uc6b0 0 \uc5d0 255) SMALLINT[(M)] [UNSIGNED] [ZEROFILL] \u2013 \ubc94\uc704 : -32768 \uc5d0\uc11c 32767 (UNSIGNED \uc77c \uacbd\uc6b0 0 \uc5d0 65535) MEDIUMINT[(M)] [UNSIGNED] [ZEROFILL] \u2013 \ubc94\uc704 : -8388608 \uc5d0\uc11c 8388607 (UNSIGNED \uc77c \uacbd\uc6b0 0 \uc5d0 16777215) INT[(M)] [UNSIGNED] [ZEROFILL] \u2013 \ubc94\uc704 : -2147483648 \uc5d0\uc11c 2147483647 (UNSIGNED &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/w3devlabs.net\/wp\/?p=1672\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;MySQL \ub370\uc774\ud130\ud615 \ubc0f \ud06c\uae30&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[25,5418],"tags":[5527,5417,5528,5529],"class_list":["post-1672","post","type-post","status-publish","format-standard","hentry","category-25","category-5418","tag-database","tag-mysql","tag-5528","tag-5529","entry"],"_links":{"self":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1672","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1672"}],"version-history":[{"count":0,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1672\/revisions"}],"wp:attachment":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1672"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1672"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1672"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}