{"id":760,"date":"2012-07-28T14:37:52","date_gmt":"2012-07-28T14:37:52","guid":{"rendered":"http:\/\/www.attob.com\/blog\/?p=760"},"modified":"2012-07-28T14:37:52","modified_gmt":"2012-07-28T14:37:52","slug":"mysql-%e3%83%87%e3%83%bc%e3%82%bf%e5%9e%8b%e3%81%ae%e6%9c%80%e5%b0%8f%e5%80%a4%e3%81%a8%e6%9c%80%e5%a4%a7%e5%80%a4","status":"publish","type":"post","link":"https:\/\/www.attob.com\/blog2\/2012\/07\/28\/mysql-%e3%83%87%e3%83%bc%e3%82%bf%e5%9e%8b%e3%81%ae%e6%9c%80%e5%b0%8f%e5%80%a4%e3%81%a8%e6%9c%80%e5%a4%a7%e5%80%a4\/","title":{"rendered":"mysql \u30c7\u30fc\u30bf\u578b\u306e\u6700\u5c0f\u5024\u3068\u6700\u5927\u5024"},"content":{"rendered":"\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\n\n\n\n\n
\u6570\u5024\u578b<\/td>\n\u6700\u5c0f\u5024<\/td>\n\u6700\u5927\u5024<\/td>\n<\/tr>\n
tinyint<\/td>\n-128<\/td>\n127<\/td>\n<\/tr>\n
tinyint(unsigned)<\/td>\n0<\/td>\n255<\/td>\n<\/tr>\n
smallint<\/td>\n-32768<\/td>\n32767<\/td>\n<\/tr>\n
smallint(unsigned)<\/td>\n0<\/td>\n65535<\/td>\n<\/tr>\n
mediumint<\/td>\n-8388608<\/td>\n8388607<\/td>\n<\/tr>\n
mediumint(unsigned)<\/td>\n0<\/td>\n16777215<\/td>\n<\/tr>\n
int<\/td>\n-2147483648<\/td>\n2147483647<\/td>\n<\/tr>\n
int(unsigned)<\/td>\n0<\/td>\n4294967295<\/td>\n<\/tr>\n
bigint<\/td>\n-9223372036854775808<\/td>\n9223372036854775807<\/td>\n<\/tr>\n
bigint(unsigned)<\/td>\n0<\/td>\n18446744073709551615<\/td>\n<\/tr>\n
decimal<\/td>\ndecimal(\u6574\u6570\u306e\u6841\u6570,\u5c0f\u6570\u70b9\u306e\u6841\u6570)\u3067\u6307\u5b9a\u3002<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\u65e5\u4ed8\u578b<\/td>\n\u6700\u5c0f\u5024<\/td>\n\u6700\u5927\u5024<\/td>\n<\/tr>\n
date<\/td>\n1000-01-01<\/td>\n9999-12-31<\/td>\n<\/tr>\n
datetime<\/td>\n1000-01-01 00:00:00<\/td>\n9999-12-31 23:59:59<\/td>\n<\/tr>\n
time<\/td>\n-838:59:59<\/td>\n838:59:59<\/td>\n<\/tr>\n
timestamp<\/td>\n1970-01-01 00:00:00<\/td>\n2037-12-31 23:59:59<\/td>\n<\/tr>\n
year(yyyy)<\/td>\n1901<\/td>\n2155<\/td>\n<\/tr>\n
year(yy)<\/td>\n1970<\/td>\n2069<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\u6587\u5b57\u5217\u578b<\/td>\n\u6700\u5c0f\u5024<\/td>\n\u6700\u5927\u5024<\/td>\n<\/tr>\n
char<\/td>\n<\/td>\n255 Byte<\/td>\n<\/tr>\n
varchar<\/td>\n<\/td>\n255 Byte<\/td>\n<\/tr>\n
tinytext<\/td>\n<\/td>\n255 Byte<\/td>\n<\/tr>\n
text<\/td>\n<\/td>\n65535 Byte<\/td>\n<\/tr>\n
mediumtext<\/td>\n<\/td>\n16777215 Byte<\/td>\n<\/tr>\n
longtext<\/td>\n<\/td>\n4294967295 Byte<\/td>\n<\/tr>\n
enum(data1,data2,…<\/td>\n<\/td>\n65535\u500b<\/td>\n<\/tr>\n
set(data1,data2,…<\/td>\n<\/td>\n64\u30bb\u30c3\u30c8<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

\u6570\u5024\u578b \u6700\u5c0f\u5024 \u6700\u5927\u5024 tinyint -128 127 tinyint(unsigned) 0 255 smallint -32768 32767 smallint(unsigned) 0 65535 mediumin […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-760","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.attob.com\/blog2\/wp-json\/wp\/v2\/posts\/760","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.attob.com\/blog2\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.attob.com\/blog2\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.attob.com\/blog2\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.attob.com\/blog2\/wp-json\/wp\/v2\/comments?post=760"}],"version-history":[{"count":0,"href":"https:\/\/www.attob.com\/blog2\/wp-json\/wp\/v2\/posts\/760\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.attob.com\/blog2\/wp-json\/wp\/v2\/media?parent=760"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.attob.com\/blog2\/wp-json\/wp\/v2\/categories?post=760"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.attob.com\/blog2\/wp-json\/wp\/v2\/tags?post=760"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}