{"id":883,"date":"2010-08-27T23:23:49","date_gmt":"2010-08-27T14:23:49","guid":{"rendered":"http:\/\/minraku.no-ip.org\/wordpress\/?p=883"},"modified":"2010-08-27T23:23:57","modified_gmt":"2010-08-27T14:23:57","slug":"heidisql%e3%81%ae%e3%82%a8%e3%83%a9%e3%83%bc%e3%83%a1%e3%83%83%e3%82%bb%e3%83%bc%e3%82%b8","status":"publish","type":"post","link":"https:\/\/www.minraku.net\/blog\/minraku\/?p=883","title":{"rendered":"HeidiSQL\u306e\u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8"},"content":{"rendered":"<p>\u30e1\u30e2<\/p>\n<p>Your change did not affect any row!<br \/>\nThis can have several causes:<br \/>\n\u3042\u306a\u305f\u306e\u5909\u5316\u306f\u3069\u3093\u306a\u884c\u306b\u3082\u5f71\u97ff\u3057\u307e\u305b\u3093\u3067\u3057\u305f!<br \/>\n\u3053\u308c\u306f\u3044\u304f\u3064\u304b\u306e\u539f\u56e0\u3092\u6301\u3064\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>?a) your changes were silently converted by the server. For instance, if you tried to update an unsigned Tinyint filed from its maximum value 255 to a higher value.<br \/>\na) \u3042\u306a\u305f\u306e\u5909\u5316\u306f\u30b5\u30fc\u30d0\u306b\u3088\u3063\u3066\u9759\u304b\u306b\u5909\u63db\u3055\u308c\u307e\u3057\u305f\u3002 \u4f8b\u3048\u3070\u3001\u3042\u306a\u305f\u304c\u6700\u5927\u304b\u3089\u30d5\u30a1\u30a4\u30eb\u3055\u308c\u305f\u672a\u7f72\u540d\u306eTinyint\u3092\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u3057\u3088\u3046\u3068\u3057\u305f\u306a\u3089\u3001\u3088\u308a\u9ad8\u3044\u5024\u306b255\u3092\u8a55\u4fa1\u3057\u307e\u3059\u3002<\/p>\n<p>b) The server could not find the source row because it was deleted from outside.<br \/>\nb) \u305d\u308c\u304c\u5916\u90e8\u304b\u3089\u524a\u9664\u3055\u308c\u305f\u306e\u3067\u3001\u30b5\u30fc\u30d0\u306f\u30bd\u30fc\u30b9\u884c\u3092\u898b\u3064\u3051\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u305b\u3093\u3067\u3057\u305f\u3002<\/p>\n<p>c) The server could not find the source row because its primary key fields were modified from outside.<br \/>\nc) \u4e3b\u30ad\u30fc\u5206\u91ce\u304c\u5916\u90e8\u304b\u3089\u5909\u66f4\u3055\u308c\u305f\u306e\u3067\u3001\u30b5\u30fc\u30d0\u306f\u30bd\u30fc\u30b9\u884c\u3092\u898b\u3064\u3051\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u305b\u3093\u3067\u3057\u305f\u3002<\/p>\n<p>\u7d50\u5c40\u306a\u306b\u3084\u3063\u3066\u3082\u30c0\u30e1\u3060\u304b\u3089\u3044\u3063\u305f\u3093\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u3066\u30c6\u30fc\u30d6\u30eb\u5185\u306e\u30c7\u30fc\u30bf\u30af\u30ea\u30a2\u3057\u3066\u3001\u305d\u308c\u304b\u3089\u9069\u5b9c\u5909\u66f4\u3057\u305fSQL\u6587\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u3088\u3046\u306b\u3057\u3066\u308b\u3051\u3069\u2026a\u3082b\u3082c\u3082\u5177\u4f53\u7684\u306b\u306a\u306b\u3084\u308a\u3083\u3044\u3044\u3093\u3058\u3083\u2026<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u30e1\u30e2 Your change did not affect any row! This can have several causes: \u3042\u306a\u305f\u306e\u5909\u5316\u306f\u3069\u3093\u306a\u884c\u306b\u3082\u5f71\u97ff\u3057\u307e\u305b\u3093\u3067\u3057\u305f! \u3053\u308c\u306f\u3044\u304f\u3064\u304b\u306e\u539f\u56e0\u3092\u6301\u3064\u3053\u3068\u304c\u3067<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,3,4],"tags":[],"class_list":["post-883","post","type-post","status-publish","format-standard","hentry","category-it","category-server","category-life"],"_links":{"self":[{"href":"https:\/\/www.minraku.net\/blog\/minraku\/index.php?rest_route=\/wp\/v2\/posts\/883","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.minraku.net\/blog\/minraku\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.minraku.net\/blog\/minraku\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.minraku.net\/blog\/minraku\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.minraku.net\/blog\/minraku\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=883"}],"version-history":[{"count":2,"href":"https:\/\/www.minraku.net\/blog\/minraku\/index.php?rest_route=\/wp\/v2\/posts\/883\/revisions"}],"predecessor-version":[{"id":885,"href":"https:\/\/www.minraku.net\/blog\/minraku\/index.php?rest_route=\/wp\/v2\/posts\/883\/revisions\/885"}],"wp:attachment":[{"href":"https:\/\/www.minraku.net\/blog\/minraku\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=883"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.minraku.net\/blog\/minraku\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=883"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.minraku.net\/blog\/minraku\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=883"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}