{"id":1664,"date":"2022-05-06T07:00:00","date_gmt":"2022-05-05T22:00:00","guid":{"rendered":"https:\/\/itinfotat.com\/?p=1664"},"modified":"2022-05-01T17:32:42","modified_gmt":"2022-05-01T08:32:42","slug":"mysql-workbench%e3%81%a7update%e3%82%84delete%e3%82%92%e5%ae%9f%e8%a1%8c%e3%81%97%e3%81%9f%e3%81%a8%e3%81%8d%e3%81%ab1175%e3%81%8c%e5%87%ba%e3%81%9f%e6%99%82%e3%81%ae%e5%af%be%e5%87%a6%e6%96%b9","status":"publish","type":"post","link":"https:\/\/itinfotat.com\/?p=1664","title":{"rendered":"MySQL Workbench\u3067update\u3084delete\u3092\u5b9f\u884c\u3057\u305f\u3068\u304d\u306b1175\u304c\u51fa\u305f\u6642\u306e\u5bfe\u51e6\u65b9\u6cd5"},"content":{"rendered":"\n<p>\u305d\u306e1<br>update\u3084delete\u306e\u524d\u306b\u4e0b\u8a181\u6587\u3092\u5b9f\u884c\u3059\u308b\u3002<\/p>\n\n\n\n<p>SET SQL_SAFE_UPDATES = 0;<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>\u305d\u306e2<br>MySQL Workbench\u306e\u8a2d\u5b9a\u3092\u5909\u66f4\u3059\u308b\u3002<\/p>\n\n\n\n<p>1.\u30e1\u30cb\u30e5\u30fc\u304b\u3089\u300cEdit\u300d -&gt; \u300cPreferences\u300d\u3092\u9078\u629e\u3057\u3066\u300cWorkbench&nbsp;Preferences\u300d\u3092\u958b\u304f\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/itinfotat.com\/wp-content\/uploads\/2022\/04\/image.png\" alt=\"\" class=\"wp-image-1669\" width=\"618\" height=\"466\" srcset=\"https:\/\/itinfotat.com\/wp-content\/uploads\/2022\/04\/image.png 981w, https:\/\/itinfotat.com\/wp-content\/uploads\/2022\/04\/image-300x227.png 300w, https:\/\/itinfotat.com\/wp-content\/uploads\/2022\/04\/image-768x580.png 768w\" sizes=\"auto, (max-width: 618px) 100vw, 618px\" \/><\/figure>\n\n\n\n<p>2.\u5de6\u5074\u306e\u30c4\u30ea\u30fc\u304b\u3089\u300cSQL Editor\u300d\u3092\u9078\u629e\u3002<\/p>\n\n\n\n<p>3.\u4e0b\u90e8\u306e\u300cSafe Updates \uff5e\u300d\u306e\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u3092\u5916\u3057\u3066\u300cOK\u300d\u3092\u62bc\u4e0b\u3059\u308b\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/itinfotat.com\/wp-content\/uploads\/2022\/04\/image-1.png\" alt=\"\" class=\"wp-image-1670\" width=\"621\" height=\"468\" srcset=\"https:\/\/itinfotat.com\/wp-content\/uploads\/2022\/04\/image-1.png 981w, https:\/\/itinfotat.com\/wp-content\/uploads\/2022\/04\/image-1-300x227.png 300w, https:\/\/itinfotat.com\/wp-content\/uploads\/2022\/04\/image-1-768x580.png 768w\" sizes=\"auto, (max-width: 621px) 100vw, 621px\" \/><\/figure>\n\n\n\n<p>4.MySQL Workbench\u3092\u518d\u8d77\u52d5\u3059\u308b\u3002<\/p>\n\n\n\n<p>\u3010\u52d5\u4f5c\u78ba\u8a8d\u74b0\u5883\u3011<br>OS\uff1aWindows10 Pro 20H2<br>MySQL Workbench\uff1a6.3.7<\/p>\n\n\n\n<p><script type=\"text\/javascript\" src=\"\/\/rot0.a8.net\/jsa\/71990cbe3032408438ae198d7bb02a4a\/e88a49bccde359f0cabb40db83ba6080.js\"><\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u305d\u306e1update\u3084delete\u306e\u524d\u306b\u4e0b\u8a181\u6587\u3092\u5b9f\u884c\u3059\u308b\u3002 SET SQL_SAFE_UPDATES = 0; \u305d\u306e2MySQL Workbench\u306e\u8a2d\u5b9a\u3092\u5909\u66f4\u3059\u308b\u3002 1.\u30e1\u30cb\u30e5\u30fc\u304b\u3089\u300cEdit\u300d -&gt; \u300cPref &hellip; <a href=\"https:\/\/itinfotat.com\/?p=1664\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;MySQL Workbench\u3067update\u3084delete\u3092\u5b9f\u884c\u3057\u305f\u3068\u304d\u306b1175\u304c\u51fa\u305f\u6642\u306e\u5bfe\u51e6\u65b9\u6cd5&#8221;\u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[84,85,4,36],"tags":[86,23,37],"class_list":["post-1664","post","type-post","status-publish","format-standard","hentry","category-mysql","category-mysql-workbench","category-windows","category-windows10","tag-mysql","tag-windows","tag-windows10"],"_links":{"self":[{"href":"https:\/\/itinfotat.com\/index.php?rest_route=\/wp\/v2\/posts\/1664","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itinfotat.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itinfotat.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itinfotat.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/itinfotat.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1664"}],"version-history":[{"count":3,"href":"https:\/\/itinfotat.com\/index.php?rest_route=\/wp\/v2\/posts\/1664\/revisions"}],"predecessor-version":[{"id":1672,"href":"https:\/\/itinfotat.com\/index.php?rest_route=\/wp\/v2\/posts\/1664\/revisions\/1672"}],"wp:attachment":[{"href":"https:\/\/itinfotat.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1664"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itinfotat.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1664"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itinfotat.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1664"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}