{"id":511,"date":"2015-02-25T11:01:23","date_gmt":"2015-02-25T20:01:23","guid":{"rendered":"\/blog\/?p=511"},"modified":"2023-09-21T09:38:41","modified_gmt":"2023-09-21T00:38:41","slug":"mysql-data-types","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=511","title":{"rendered":"MySQL Data Types"},"content":{"rendered":"\n<p><em><strong><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">MySQL \ud544\ub4dc\uc758 \ub370\uc774\ud130 \ud0c0\uc785 \uc815\ub9ac<\/span><\/strong><\/em><\/p>\r\n<p><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">(\ub300\ubd80\ubd84 MS-SQL,Access \uc640 \ube44\uc2b7\ud558\uc9c0\ub9cc \uba87\uac00\uc9c0\uac00 \ud2c0\ub9bc,<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">\ub610\ud55c Access \uc758 \uacbd\uc6b0, \uc774\uc81c \ub354\uc774\uc0c1 \uc5c5\uadf8\ub808\uc774\ub4dc\uac00 \ub418\uc9c0 \uc54a\uc9c0\ub9cc,<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">MS-SQL \uc758 \uacbd\uc6b0, \uacc4\uc18d \uc5c5\uadf8\ub808\uc774\ub4dc \ub418\uba74\uc11c \ud544\ub4dc \ud0c0\uc785\ub3c4 \ucd94\uac00\ub418\ub294 \ucd94\uc138\uc784<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">\ub300\ud45c\uc801\uc608: MS-SQL2005 \ubc84\uc804\uc5d0\uc11c\ub294 smallint,bigint \ub4f1 \uc0c8\ub85c\uc6b4 \ud0c0\uc785\uc774 \ucd94\uac00\ub418\uc5c8\uc74c?)<\/span><br \/><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">-----------------------------------------------------------------------<\/span><br \/><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\ub294 \ud06c\uac8c \ub2e4\uc74c\uacfc \uac19\uc740 \uc138 \uac00\uc9c0 \ub370\uc774\ud130 \ud0c0\uc785\uc774 \uc788\ub2e4.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">===========================================================<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">\ub370\uc774\ud130\ud0c0\uc785 \ub0b4\uc6a9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \uc608\uc81c<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">-----------------------------------------------------------<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">\uc22b\uc790\ud615&nbsp;&nbsp;&nbsp;&nbsp; \uc22b\uc790\ub97c \uc800\uc7a5\ud558\ub294 \ud544\ub4dc&nbsp; TINYINT, INT, FLOAT<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">-----------------------------------------------------------<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">\ubb38\uc790\ud615&nbsp;&nbsp;&nbsp;&nbsp; \ubb38\uc790\ub97c \uc800\uc7a5\ud558\ub294 \ud544\ub4dc&nbsp; CHAR, VARCHAR, TEXT, ENUM<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">-----------------------------------------------------------<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">\ub0a0\uc9dc\ud615&nbsp;&nbsp;&nbsp;&nbsp; \ub0a0\uc9dc\ub97c \uc800\uc7a5\ud558\ub294 \ud544\ub4dc&nbsp; DATE, DATETIME, TIMESTAMP<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">===========================================================<\/span><br \/><br \/><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">MySQL \ub370\uc774\ud130 \ud0c0\uc785\uc758 \ubaa8\ub4e0 \uc885\ub958\ub97c \uc678\uc6b8 \ud544\uc694\ub294 \uc5c6\ub2e4.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">\uadf8\ub7ec\ub098, \ub2e4\uc74c\uc758 \ub124 \uac00\uc9c0 \ub370\uc774\ud130 \ud0c0\uc785\uc740 \uc0c1\ub2f9\ud788 \ub9ce\uc774 \uc0ac\uc6a9\ub418\ubbc0\ub85c \uaf2d \uc775\ud600\ub458\uac83<\/span><br \/><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">INT : 4bytes \uc815\uc218\ub97c \uc800\uc7a5\ud560\ub54c \uc0ac\uc6a9<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">CHAR(n) : \ubb38\uc790\uc758 \uc218\uac00 n \uac1c\uc778 \ubb38\uc790\uc5f4\uc744 \uc800\uc7a5\ud560\ub54c \uc0ac\uc6a9<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">VARCHAR(n) \ubb38\uc790\uc758 \uc218\uac00 \ucd5c\ub300 n \uac1c\uc778 \ubb38\uc790\uc5f4\uc744 \uc800\uc7a5\ud560\ub54c \uc0ac\uc6a9<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">TEXT : \ubb38\uc790\uc758 \uc218\uac00 \ucd5c\ub300 65535 \uac1c\uc778 \ubb38\uc790\uc5f4\uc744 \uc800\uc7a5\ud560\ub54c \uc0ac\uc6a9<\/span><br \/><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">\uc8fc\uc758: char \ud0c0\uc785\uc740 \ubb34\uc870\uac74 n \uae38\uc774\ub9cc\ud07c\uc744 \ucc28\uc9c0\ud558\uace0, \ucd9c\ub825\uc2dc\uc5d0\ub3c4 n \uae38\uc774\ub85c \uccb4\ud06c\ub418\uc9c0\ub9cc, varchar \uc740 \uc2e4\uc81c\ub85c \ub4e4\uc5b4\uc788\ub294 \ubb38\uc790\uae38\uc774\ub9cc\ud07c \uc778\uc2dd\ub41c\ub2e4.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">\ub610\ud55c, int \ud615\uc758 \uacbd\uc6b0, \uc55e\uc5d0 0 \uc744 \ubd99\uc5ec \uc800\uc7a5\ud574\ub3c4 0 \uc774 \uc5c6\uc5b4\uc9c0\uace0, \uccab\uc790\ub9ac\ub294 0 \uc774 \uc544\ub2cc \uc22b\uc790\uac00 \ub098\uc62c\ub54c\uae4c\uc9c0 0 \uc774 \uc5c6\uc5b4\uc9c4\ub2e4.<\/span><br \/><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">\ub2e4\uc74c\uc740 \uc22b\uc790\ud615, \ub0a0\uc9dc\ud615, \uadf8\ub9ac\uace0 \ubb38\uc790\ud615\uc758 \ub370\uc774\ud130 \ud0c0\uc785\uc744 \uc815\ub9ac\ud574\ub454 \ud45c\uc774\ub2e4.<\/span><br \/><\/p>\r\n<p><br \/><\/p>\r\n<p><br \/><\/p>\r\n<p><br \/><strong><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">\uc22b\uc790\ud615 \ub370\uc774\ud130 \ud0c0\uc785<\/span><\/strong><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">=====================================================================================<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">\ub370\uc774\ud130\ud0c0\uc785&nbsp;&nbsp; \uc124\uba85<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">-------------------------------------------------------------------------------------<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">TINYINT&nbsp;&nbsp; \uac00\uc7a5 \uc791\uc740 \uc22b\uc790\ud615\uc73c\ub85c \ubd80\ud638\uac00 \uc788\ub294 \uacbd\uc6b0\uc5d0\ub294 -128 ~ 127,<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \ubd80\ud638\uac00 \uc5c6\ub294 \uacbd\uc6b0\uc5d0\ub294 0 ~ 255 \uae4c\uc9c0 \ub370\uc774\ud130\ub97c \ub2e4\ub8f0 \uc218 \uc788\ub2e4.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \uc800\uc7a5\ud560\ub54c \ud544\uc694\ud55c \uc6a9\ub7c9\uc740 1\ubc14\uc774\ud2b8\uc774\ub2e4.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">-------------------------------------------------------------------------------------<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">SMALLINT&nbsp; \ubd80\ud638\uac00 \uc788\ub294 \uacbd\uc6b0\uc5d0\ub294 -32768 ~ 32767,<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \ubd80\ud638\uac00 \uc5c6\ub294 \uacbd\uc6b0\uc5d0\ub294 0 ~ 65535 \uae4c\uc9c0 \ub2e4\ub8f0 \uc218 \uc788\uc73c\uba70,<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \uc800\uc7a5\ud560\ub54c \ud544\uc694\ud55c \uc6a9\ub7c9\uc740 2\ubc14\uc774\ud2b8\uc774\ub2e4.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">-------------------------------------------------------------------------------------<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">MEDIUMINT \ubd80\ud638\uac00 \uc788\ub294 \uacbd\uc6b0\uc5d0\ub294 -8388608 ~ 8388607,<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \ubd80\ud638\uac00 \uc5c6\ub294 \uacbd\uc6b0\uc5d0\ub294 0 ~ 16777215 \uae4c\uc9c0 \ub370\uc774\ud130\ub97c \ub2e4\ub8f0 \uc218 \uc788\uc73c\uba70,<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \uc800\uc7a5\ud560\ub54c \ud544\uc694\ud55c \uc6a9\ub7c9\uc740 3\ubc14\uc774\ud2b8\uc774\ub2e4.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">-------------------------------------------------------------------------------------<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">INT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \uc77c\ubc18\uc801\uc73c\ub85c \uc0ac\uc6a9\ud558\ub294 \uc22b\uc790\ud615\uc73c\ub85c<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \ubd80\ud638\uac00 \uc788\ub294 \uacbd\uc6b0\uc5d0\ub294 -2147483648 ~ 2144483647,<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \ubd80\ud638\uac00 \uc5c6\ub294 \uacbd\uc6b0\uc5d0\ub294 0 ~ 4294967295 \uae4c\uc9c0 \ub370\uc774\ud130\ub97c \ub2e4\ub8f0 \uc218 \uc788\uc73c\uba70,<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \uc800\uc7a5\ud560\ub54c \ud544\uc694\ud55c \uc6a9\ub7c9\uc740 4\ubc14\uc774\ud2b8\uc774\ub2e4.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">-------------------------------------------------------------------------------------<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">INTEGER&nbsp;&nbsp; int \uc640 \uac19\uc774 \uc0ac\uc6a9\ud55c\ub2e4.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (int \uc640 \uac19\uc740 \ub73b\uc778\ub4ef\ud558\uba70, \uc774\ub984\ub9cc \ub2ec\ub9ac \uc0ac\uc6a9)<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">-------------------------------------------------------------------------------------<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">BIGINT&nbsp;&nbsp;&nbsp; \ubd80\ud638\uac00 \uc788\ub294 \uacbd\uc6b0\uc5d0\ub294 -922337036854775808 ~ 922337036854775807,<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \ubd80\ud638\uac00 \uc5c6\ub294 \uacbd\uc6b0\uc5d0\ub294 0 ~ 18446744073709551615 \uae4c\uc9c0 \ub370\uc774\ud130\ub97c \ub2e4\ub8f0 \uc218 \uc788\uc73c\uba70,<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \uc800\uc7a5\ud560\ub54c \ud544\uc694\ud55c \uc6a9\ub7c9\uc740 8\ubc14\uc774\ud2b8\uc774\ub2e4.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">-------------------------------------------------------------------------------------<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">FLOAT&nbsp;&nbsp;&nbsp;&nbsp; \ucd5c\uc18c\uac12 +_1.175494351E-38 ~ \ucd5c\ub300\uac12 +_3.402823466E_38 \uae4c\uc9c0 \uc9c0\uc6d0,<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4\ubc14\uc774\ud2b8\uc758 \ud06c\uae30\ub97c \uac00\uc9c4\ub2e4.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">-------------------------------------------------------------------------------------<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">DOUBLE&nbsp;&nbsp;&nbsp; \ucd5c\uc18c \u00b11.7976931348623157E-308, \ucd5c\ub300 \u00b12.2250738585072014E+308 \uc774\uba70,<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \uc800\uc7a5\ud560\ub54c \ud544\uc694\ud55c \uc6a9\ub7c9\uc740 8\ubc14\uc774\ud2b8\uc774\ub2e4.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">-------------------------------------------------------------------------------------<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">DECIMAL&nbsp;&nbsp; \uc18c\uc218\ub97c \uc800\uc7a5\ud558\uc9c0\ub9cc \ub0b4\ubd80\uc801\uc73c\ub85c\ub294 \ubb38\uc790 \ud615\ud0dc\ub85c \uc800\uc7a5\ub418\ub294 \ud0c0\uc785\uc774\ub2e4.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \uc608\ub97c\ub4e4\uc5b4 3.141592 \uc758 \uacbd\uc6b0, 3 \uc774 char \ud558\ub098\uc758 \uacf5\uac04\uc5d0 \uc800\uc7a5\ub41c\ub2e4.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">=====================================================================================<\/span><br \/><br \/><br \/><br \/><br \/><strong><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">\ubb38\uc790\ud615 \ub370\uc774\ud130 \ud0c0\uc785<\/span><\/strong><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">=====================================================================================<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">\ub370\uc774\ud130\ud0c0\uc785&nbsp; \uc124\uba85<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">-------------------------------------------------------------------------------------<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">CHAR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; char(0) \ub3c4 \uc9c0\uc6d0\ud558\uba70,<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \uc2e4\uc81c\uac12\uc774 M\ubcf4\ub2e4 \uc791\uc744 \ub54c \ub0a8\ub294 \uc790\ub9bf\uc218\ub9cc\ud07c \uacf5\ubc31\uc744 \ubd99\uc5ec\uc11c \uc800\uc7a5\ud55c\ub2e4.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1\ubd80\ud130 \ucd5c\ub300 255 \uc758 \uc790\ub9bf\uc218\ub97c \uc9c0\uc6d0\ud558\uba70, \uc9c0\uc815\ud55c \uc6a9\ub7c9\ub9cc\ud07c \ubc14\uc774\ud2b8\ub97c \uc0ac\uc6a9.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">-------------------------------------------------------------------------------------<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">VARCHAR&nbsp;&nbsp;&nbsp; \uc9c0\uc815\ud560 \uc218 \uc788\ub294 \uae38\uc774\ub294 1\ubd80\ud130 255\uae4c\uc9c0\uc774\uba70,<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \uc9c0\uc815\ud55c \uae38\uc774\ubcf4\ub2e4 \uc791\uc740 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud560\ub54c \ud544\uc694\ud55c \uae38\uc774\ub9cc\ud07c \uc800\uc7a5\ub41c\ub2e4.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; char \ud615\ubcf4\ub2e4 \uae30\uc5b5\uc7a5\uce58\ub97c \ud6a8\uc728\uc801\uc73c\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4. \uc9c0\uc815\ud55c\uc6a9\ub7c9+1\ubc14\uc774\ud2b8 \uc0ac\uc6a9.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">-------------------------------------------------------------------------------------<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">TINYBLOB&nbsp;&nbsp; \ucd5c\ub300 255\uac1c\uc758 \ubb38\uc790\ub97c \uc800\uc7a5. \uc9c0\uc815\ud55c \uc6a9\ub7c9+1\ubc14\uc774\ud2b8(L &lt; 2^8 -1) \ub97c \uc0ac\uc6a9.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">-------------------------------------------------------------------------------------<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">TINYTEXT&nbsp;&nbsp; tinyblob \uc640 \uac19\uc774 \uc0ac\uc6a9(\uc774\ub984\ub9cc \ub2e4\ub978\ub4ef)<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">-------------------------------------------------------------------------------------<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">BLOB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \ucd5c\ub300 65535 \uac1c\uc758 \ubb38\uc790\ub97c \uc800\uc7a5. \uc9c0\uc815\ud55c \uc6a9\ub7c9+2\ubc14\uc774\ud2b8(L &lt; 2^16 -1)\uc758 \uc6a9\ub7c9 \uc0ac\uc6a9.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">-------------------------------------------------------------------------------------<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">TEXT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; blob \uc640 \uac19\uc774 \uc0ac\uc6a9(\uc774\ub984\ub9cc \ub2e4\ub978\ub4ef)<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">-------------------------------------------------------------------------------------<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">MEDIUMBLOB \ucd5c\ub300 16777215 \uac1c\uc758 \ubb38\uc790\ub97c \uc800\uc7a5. \uc9c0\uc815\ud55c \uc6a9\ub7c9+3\ubc14\uc774\ud2b8(L &lt; 2^24 -1) \ub97c \uc0ac\uc6a9.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">-------------------------------------------------------------------------------------<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">MEDIUMTEXT mediumblob \uc640 \uac19\uc774 \uc0ac\uc6a9(\uc774\ub984\ub9cc \ub2e4\ub978\ub4ef)<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">-------------------------------------------------------------------------------------<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">LONGBLOB&nbsp;&nbsp; \ucd5c\ub300 429496729 \uac1c\uc758 \ubb38\uc790\ub97c \uc800\uc7a5. \uc9c0\uc815\ud55c \uc6a9\ub7c9+4\ubc14\uc774\ud2b8(L &lt; 2^32 -1) \ub97c \uc0ac\uc6a9.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">-------------------------------------------------------------------------------------<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">LONGTEXT&nbsp;&nbsp; longbolb \uc640 \uac19\uc774 \uc0ac\uc6a9(\uc774\ub984\ub9cc \ub2e4\ub978\ub4ef)<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">-------------------------------------------------------------------------------------<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">ENUM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \ubb38\uc790 \ud615\ud0dc\uc778 value \ub97c \uc22b\uc790\ub85c \uc800\uc7a5.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; value \uc911\uc5d0 \ud558\ub098\ub9cc \uc800\uc7a5\ud558\uba70, value \uac00 255 \uc774\ud558\uc778 \uacbd\uc6b0\uc5d0\ub294 1\ubc14\uc774\ud2b8,<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 65535 \uc774\ud558\uc778 \uacbd\uc6b0\uc5d0\ub294 2\ubc14\uc774\ud2b8\ub97c \uc0ac\uc6a9.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">=====================================================================================<\/span><br \/><br \/><br \/><br \/><br \/><strong><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">\ub0a0\uc9dc\ud615 \ub370\uc774\ud130 \ud0c0\uc785<\/span><\/strong><\/p>\r\n<p><span style=\"font-family: Courier New; font-size: 9pt;\"><\/span><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">PHP \uc758 \ub0a0\uc9dc \ubc0f \uc2dc\uac04 \uad00\ub828 \ud568\uc218\uc640 \ube44\uc2b7\ud558\ub2e4.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">=====================================================================================<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">DATE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '1001-01-01' \ubd80\ud130 '9999-12-31' \uae4c\uc9c0\uc758 \uac12\uc774 \ub4e4\uc5b4\uac08 \uc218 \uc788\uc73c\uba70,<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \uc800\uc7a5\ud560\ub54c 3\ubc14\uc774\ud2b8\uac00 \ud544\uc694. 'YYYY-MM-DD' \uc640 \uac19\uc740 \ud615\uc2dd.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">-------------------------------------------------------------------------------------<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">DATETIME&nbsp; \ub0a0\uc790\uc640 \uc2dc\uac04\uc744 \uac19\uc774 \uc800\uc7a5\ud558\uba70,<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '1001-01-01 00:00:00' \ubd80\ud130 '9999-12-31 23:59:59' \uae4c\uc9c0\uc758 \uac12\uc744 \ub2e4\ub8e8\uace0,<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8\ubc14\uc774\ud2b8\uac00 \ud544\uc694.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'YYYY-MM-DD HH:MM:SS' \uc640 \uac19\uc740 \ud615\uc2dd.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">-------------------------------------------------------------------------------------<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">TIMESTAMP '1970-01-01 00:00:00' \uc774\ud6c4\ubd80\ud130 \ucd08\ub97c \uc22b\uc790\ub85c \uc800\uc7a5\ud558\ub294 \uc790\ub8cc\ud615\uc73c\ub85c,<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4\ubc14\uc774\ud2b8\uac00 \ud544\uc694.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \uc57d 40\uc5b5\ucd08\ub97c \uc800\uc7a5\ud560 \uc218 \uc788\uc73c\ubbc0\ub85c 2037\ub144\uae4c\uc9c0\uc758 \uac12\uc744 \ub2e4\ub8f0 \uc218 \uc788\ub2e4.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">-------------------------------------------------------------------------------------<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">TIME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '-838:59:59' \uc5d0\uc11c '838:59:59' \uc758 \uac12\uc744 \ub2e4\ub8e8\uba70,<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3\ubc14\uc774\ud2b8\ub97c \uc0ac\uc6a9.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; HH:MM:SS \uc640 \uac19\uc740 \ud615\uc2dd<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">-------------------------------------------------------------------------------------<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">YEAR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \uc5f0\ub3c4\ub9cc \uc800\uc7a5\ud558\ub294 \uc790\ub8cc\ud615\uc774\ub2e4.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; year(n)? \uc640 \uac19\uc740 \ud615\uc2dd.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; n \uc740 2\uc640 4\ub97c \uc9c0\uc815\ud560 \uc218 \uc788\uc73c\uba70, 2\uc778 \uacbd\uc6b0\uc5d0 \uac12\uc758 \ubc94\uc704\ub294 70 \uc5d0\uc11c 69,<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4\uc778 \uacbd\uc6b0\uc5d0\ub294 1970 \uc5d0\uc11c 2069 \uc774\ub2e4.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1\ubc14\uc774\ud2b8\ub97c \uc0ac\uc6a9.<\/span><br \/><span style=\"font-family: \uad74\ub9bc\uccb4, 'Courier New', Terminal; font-size: 9pt;\">=====================================================================================<\/span><br \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL \ud544\ub4dc\uc758 \ub370\uc774\ud130 \ud0c0\uc785 \uc815\ub9ac (\ub300\ubd80\ubd84 MS-SQL,Access \uc640 \ube44\uc2b7\ud558\uc9c0\ub9cc \uba87\uac00\uc9c0\uac00 \ud2c0\ub9bc,\ub610\ud55c Access \uc758 \uacbd\uc6b0, \uc774\uc81c \ub354\uc774\uc0c1 \uc5c5\uadf8\ub808\uc774\ub4dc\uac00 \ub418\uc9c0 \uc54a\uc9c0\ub9cc,MS-SQL \uc758 \uacbd\uc6b0, \uacc4\uc18d \uc5c5\uadf8\ub808\uc774\ub4dc \ub418\uba74\uc11c \ud544\ub4dc \ud0c0\uc785\ub3c4 \ucd94\uac00\ub418\ub294 \ucd94\uc138\uc784\ub300\ud45c\uc801\uc608: MS-SQL2005 \ubc84\uc804\uc5d0\uc11c\ub294 smallint,bigint \ub4f1 \uc0c8\ub85c\uc6b4 \ud0c0\uc785\uc774 \ucd94\uac00\ub418\uc5c8\uc74c?) &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\ub294 \ud06c\uac8c \ub2e4\uc74c\uacfc \uac19\uc740 \uc138 \uac00\uc9c0 \ub370\uc774\ud130 \ud0c0\uc785\uc774 \uc788\ub2e4.===========================================================\ub370\uc774\ud130\ud0c0\uc785 \ub0b4\uc6a9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \uc608\uc81c&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;\uc22b\uc790\ud615&nbsp;&nbsp;&nbsp;&nbsp; \uc22b\uc790\ub97c \uc800\uc7a5\ud558\ub294 \ud544\ub4dc&nbsp; TINYINT, INT, FLOAT&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;\ubb38\uc790\ud615&nbsp;&nbsp;&nbsp;&nbsp; \ubb38\uc790\ub97c [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[10],"tags":[],"class_list":["post-511","post","type-post","status-publish","format-standard","hentry","category-computing_database"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/511","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=511"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/511\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=511"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=511"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=511"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}