{"author_url":"https://blog.hatena.ne.jp/kenken0807/","type":"rich","title":"Instant Add Column\u3057\u3066\u5168\u884cUPDATE\u3057\u3066\u307f\u308b","description":"MySQL8.0\u306e Instant Add Column\u3067\u8ffd\u52a0\u3057\u305f\u30ab\u30e9\u30e0\u3092\u5168\u884cupdate\u3059\u308b\u3068\u30c7\u30fc\u30bf\u30b5\u30a4\u30ba\u3068\u304b\u5b9f\u884c\u6642\u9593\u3068\u3068\u304b\u3069\u3046\u306a\u308b\u304b\u8a66\u3057\u3066\u307f\u305f\u3002 \u307e\u305a\u3001 Instant Add Column\u3068\u306f... \u30c7\u30fc\u30bf\u30c7\u30a3\u30af\u30b7\u30e7\u30ca\u30ea\u306e\u307f\u3092\u5909\u66f4\u3059\u308b\u3053\u3068\u3067\u3001add column\u51e6\u7406\u304c\u5373\u6642\u3067\u5b8c\u4e86\u3059\u308b\u64cd\u4f5c\u3002 ALTER TABLE t2 ADD id3 int not null default 0 , ALGORITHM = INSTANT ; Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 \u3053\u3093\u306a\u611f\u3058\u3067\u5b9f\u884c\u2026","height":"190","version":"1.0","provider_url":"https://hatena.blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fkenken0807.hatenablog.com%2Fentry%2F2019%2F03%2F18%2F173600\" title=\"Instant Add Column\u3057\u3066\u5168\u884cUPDATE\u3057\u3066\u307f\u308b - kenken0807_DB\u30e1\u30e2\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","author_name":"kenken0807","blog_title":"kenken0807_DB\u30e1\u30e2","width":"100%","image_url":null,"published":"2019-03-18 17:36:00","blog_url":"https://kenken0807.hatenablog.com/","provider_name":"Hatena Blog","url":"https://kenken0807.hatenablog.com/entry/2019/03/18/173600","categories":["MySQL"]}