{"id":640,"date":"2021-09-29T23:10:09","date_gmt":"2021-09-29T14:10:09","guid":{"rendered":"https:\/\/suzutukiblog.com\/?p=640"},"modified":"2023-01-05T23:52:40","modified_gmt":"2023-01-05T14:52:40","slug":"mysql2","status":"publish","type":"post","link":"https:\/\/suzutukiblog.com\/index.php\/2021\/09\/29\/mysql2\/","title":{"rendered":"MySQL(\u305d\u306e\uff12\u30c7\u30fc\u30bf\u578b\u306b\u3064\u3044\u3066\uff09"},"content":{"rendered":"

1\u304b\u3089\u7d9a\u304d\u307e\u3059<\/a><\/p>\n

1:\u30c7\u30fc\u30bf\u578b\u3068\u306f\uff1f<\/h3>\n

\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u306f\u3001\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3059\u308b\u3068\u304d\u306b\u3001\u305d\u308c\u305e\u308c\u306e\u5217\u306b\u6307\u5b9a\u3057\u305f\u5f62\u5f0f\u306e\u30c7\u30fc\u30bf\u3057\u304b\u3001
\n\u5165\u529b\u3067\u304d\u306a\u3044\u3088\u3046\u306b\u8a2d\u5b9a\u3059\u308b\u3002<\/p>\n

\u3053\u306e\u6642\u6307\u5b9a\u3059\u308b\u30c7\u30fc\u30bf\u306e\u5f62\u5f0f\u306e\u3053\u3068\u3092\u30c7\u30fc\u30bf\u578b\u3068\u3044\u3046<\/p>\n

2:\u30c7\u30fc\u30bf\u578b\u306e\u7a2e\u985e(\u6570\u5024\u578b)<\/h3>\n

\u30fbint\u578b<\/strong>\uff1a\u6574\u6570(-2147483648~-2147483647)<\/p>\n

\u30fbint unsigned<\/strong>:\u7b26\u53f7\u7121\u3057\u3068\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3002\u3064\u307e\u308a\u6b63\u306e\u6574\u6570\u3060\u3051\u3092\u6271\u3046\u3053\u3068\u3067\u3001\u6271\u3048\u308b\u5024\u306e\u7bc4\u56f2\u304c\u5897\u3048\u308b<\/p>\n

\u30fbtinyint\u578b<\/strong>\uff1a\u3068\u3066\u3082\u5c0f\u3055\u306a\u6574\u6570(-128~127)<\/p>\n

\u30fbtinyint(1)<\/strong>:\u771f\u507d\u5024true\/false\u3092\u6271\u3046\u3053\u3068\u304c\u3067\u304d\u308b<\/p>\n

\u5185\u90e8\u7684\u306b\u306ftrue\u306f\u6570\u5b57\u306e1\u3001false\u306f\u6570\u5b57\u306e0\u3067\u7ba1\u7406\u3055\u308c\u3066\u3044\u308b\u3002<\/p>\n

MySQL\u3067\u306f0\u3068null\u304cfalse\u3067\u3001\u7a7a\u6587\u5b57\u3092\u542b\u3080\u305d\u308c\u4ee5\u5916\u306e\u5024\u306f\u3059\u3079\u3066true\u3068\u306a\u308b\u3002<\/p>\n

null:\u30c7\u30fc\u30bf\u304c\u5b58\u5728\u3057\u306a\u3044\u3053\u3068\u3092\u8868\u3059\u5024<\/p>\n

\u30fbfloat\u578b<\/strong>\uff1a\u5c0f\u3055\u3044\u6d6e\u52d5\u5c0f\u6570\u70b9\u6570 (-3.402823466E+38\u301c-1.175494351E-38,0,\u304a\u3088\u3073\u30011.175494351E-38\u301c-3.402823466E+38)E\u306f10n<\/sup>\u306a\u306e\u30671.175494351E-38\u306f1.175494351\u00d71038<\/sup><\/p>\n

\u30fbdouble\u578b<\/strong>\uff1a\u6d6e\u52d5\u5c0f\u6570\u70b9\u6570(-1.7976931348623157E+308~2.2250738585072014E-308,0\u304a\u3088\u3073\u30012.2250738585072014E-308~1.7976931348623157E+308)<\/p>\n

\u5b9f\u52d9\u4e0a\u6574\u6570\u578b\u306fint\u3001\u6574\u6570\u306e\u4e2d\u3067\u3082\u3001\u771f\u507d\u5024\u3092\u6271\u3044\u305f\u3044\u3068\u304d\u3084\u3001127\u4ee5\u4e0b\u306e\u6570\u5b57\u3092\u6271\u3046\u3068\u304d\u306ftinyint\u3001\u5c0f\u6570\u3092\u6271\u3046\u3068\u304d\u306f\u3001double\u3092\u4f7f\u3046\u3053\u3068\u304c\u591a\u3044\u3089\u3057\u3044\u3002<\/p>\n

float\u306f\u3001\u3042\u307e\u308a\u4f7f\u308f\u308c\u306a\u3044\u3088\u3046\u3067\u3059\u3002<\/p>\n

<\/p>\n

3:\u30c7\u30fc\u30bf\u578b\u306e\u7a2e\u985e(\u6587\u5b57\u5217\u578b)<\/h3>\n

\u30fbchar\u578b<\/strong>\uff1a\u56fa\u5b9a\u9577\u306e\u6587\u5b57\u5217255\u6587\u5b57\u307e\u3067\u3001\u6587\u5b57\u5217\u3092\u683c\u7d0d\u3059\u308b\u6642\u306b\u6307\u5b9a\u3057\u305f\u9577\u3055\u306b\u306a\u308b\u3088\u3046\u306b\u30b9\u30da\u30fc\u30b9\u304c\u57cb\u3081\u8fbc\u307e\u308c\u308b\u3002<\/p>\n

\u4f8b\uff09\u5546\u54c1\u30b3\u30fc\u30c9\u30675\u6841\u56fa\u5b9a”CD123″\u3002\u5b9a\u7fa9\u65b9\u6cd5\uff1achar(5)<\/p>\n

\u30fbvarchar\u578b\uff1a\u53ef\u5909\u9577\u306e\u6587\u5b57\u5217255\u6587\u5b57\u307e\u3067<\/p>\n

\u4f8b\uff09email”tota@example.com”\u3002\u5b9a\u7fa9\u65b9\u6cd5\uff1avarchar(255)<\/p>\n

\u30fbtext\uff1a\u9577\u3044\u6587\u5b57\u521765535\u6587\u5b57\u307e\u3067<\/p>\n

\u5b9f\u52d9\u4e0a\u306f\u3001255\u6587\u5b57\u307e\u3067\u306fvarchar,\u305d\u308c\u4ee5\u4e0a\u306ftext\u3068\u3059\u308b\u3053\u3068\u304c\u591a\u3044\u3089\u3057\u3044\u3002<\/p>\n

4:\u30c7\u30fc\u30bf\u578b\u306e\u7a2e\u985e(\u65e5\u4ed8\u30fb\u6642\u523b\u578b)<\/h3>\n

\u30fbdate\u578b\uff1a\u65e5\u4ed8’1000-01-01’\u301c’9999-12-31′<\/p>\n

\u30fbdatetaime\u578b\uff1a\u65e5\u4ed8\u3068\u6642\u523b’1000-01-01 00:00:00.000000’\u301c’9999-12-31 23:59:59.999999′<\/p>\n

\u30fbtime\u578b\uff1a\u6642\u523b’-838:59:59’\u301c’838:59:59′<\/p>\n

\u305d\u306e3\u306b\u7d9a\u304f<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

1\u304b\u3089\u7d9a\u304d\u307e\u3059 1:\u30c7\u30fc\u30bf\u578b\u3068\u306f\uff1f \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u306f\u3001\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3059\u308b\u3068\u304d\u306b\u3001\u305d\u308c\u305e\u308c\u306e\u5217\u306b\u6307\u5b9a\u3057\u305f\u5f62\u5f0f\u306e\u30c7\u30fc\u30bf\u3057\u304b\u3001 \u5165\u529b\u3067\u304d\u306a\u3044\u3088\u3046\u306b\u8a2d\u5b9a\u3059\u308b\u3002 \u3053\u306e\u6642\u6307\u5b9a\u3059\u308b\u30c7\u30fc\u30bf\u306e\u5f62\u5f0f\u306e\u3053\u3068\u3092\u30c7\u30fc\u30bf\u578b\u3068\u3044\u3046 2:\u30c7\u30fc\u30bf\u578b\u306e\u7a2e\u985e […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[5,27],"tags":[],"class_list":["post-640","post","type-post","status-publish","format-standard","hentry","category-mysql","category-programming-note"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t