{"image_url":null,"author_name":"rx7","type":"rich","blog_url":"https://www.na3.jp/","version":"1.0","width":"100%","blog_title":"\u5143RX-7\u4e57\u308a\u306e\u9069\u5f53\u306a\u65e5\u3005","provider_name":"Hatena Blog","height":"190","description":"\u203b \u3053\u306e\u30a8\u30f3\u30c8\u30ea\u306f\u3001\u306f\u3066\u306a\u30b0\u30eb\u30fc\u30d7\u7d42\u4e86\u306b\u4f34\u3046\u3001\u30b5\u30d6\u30d6\u30ed\u30b0\u304b\u3089\u306e\u5f15\u8d8a\u30a8\u30f3\u30c8\u30ea(2014/07)\u3067\u3059\u3002 \u203b \u60c5\u5831\u304c\u53e4\u3044\u53ef\u80fd\u6027\u3082\u3042\u308a\u307e\u3059\u306e\u3067\u3001\u3054\u7559\u610f\u304f\u3060\u3055\u3044\u3002 pt-online-schema-change \u3092\u4f7f\u3063\u3066\u3044\u305f\u3089\u3001\u3053\u3093\u306a\u30a8\u30e9\u30fc\u304c\u51fa\u305f\u3002 \u66f8\u3044\u3066\u3042\u308b\u3068\u304a\u308a\u3060\u304c\u3001PRIMARY KEY \u304b unique index \u304c\u7121\u3044\u3068 DELETE \u306e\u969b\u306e\u30c8\u30ea\u30ac\u306e\u6319\u52d5\u3067\u6574\u5408\u6027\u304c\u53d6\u308c\u306a\u304f\u306a\u308b\u3068\u304b\u306a\u306e\u3060\u308d\u3046\u3002","published":"2020-01-12 23:55:00","provider_url":"https://hatena.blog","categories":["IT"],"title":"\"The new table `DATABASE`.`_TABLE_new` does not have a PRIMARY KEY or a unique index which is required for the DELETE trigger.\"","author_url":"https://blog.hatena.ne.jp/rx7/","url":"https://www.na3.jp/entry/20200112/p1","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.na3.jp%2Fentry%2F20200112%2Fp1\" title=\"&quot;The new table `DATABASE`.`_TABLE_new` does not have a PRIMARY KEY or a unique index which is required for the DELETE trigger.&quot; - \u5143RX-7\u4e57\u308a\u306e\u9069\u5f53\u306a\u65e5\u3005\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>"}