{"blog_url":"https://sakaik.hateblo.jp/","categories":["mysql"],"version":"1.0","author_url":"https://blog.hatena.ne.jp/sakaik/","type":"rich","width":"100%","provider_name":"Hatena Blog","title":"MySQL \u306e Generated Invisible PK(GIPK)\u3092\u8a66\u3059","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fsakaik.hateblo.jp%2Fentry%2F20220804%2Fgipk_on_mysql_8030\" title=\"MySQL \u306e Generated Invisible PK(GIPK)\u3092\u8a66\u3059 - sakaik\u306e\u65e5\u3005\u96d1\u611f\uff5e(T)\u7de8\" 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":"sakaik","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/s/sakaik/20220804/20220804235450.png","description":"7\u6708\u306b\u30ea\u30ea\u30fc\u30b9\u3055\u308c\u305f MySQL 8.0.30 \u3067\u306f\u300cGenerated Invisible Primary Key(GIPK)\u300d\u3068\u3044\u3046\u6a5f\u80fd\u304c\u8ffd\u52a0\u3055\u308c\u307e\u3057\u305f\u3002\u5404\u30c6\u30fc\u30d6\u30eb\u306bPK\u304c\u3042\u308b\u3053\u3068\u3092\u5fc5\u9808\u3068\u3057\u3001\u306a\u3044\u5834\u5408\u306f\u30c6\u30fc\u30d6\u30eb\u4f5c\u6210\u6642\u306b\u81ea\u52d5\u7684\u306b\u4e0d\u53ef\u8996\u5217\u3068\u3057\u3066AUTO_INCREMENT\u306aPK\u5217\u3092\u8ffd\u52a0\u3057\u3066\u304f\u308c\u308b\u3001\u3068\u3044\u3046\u6a5f\u80fd\u3067\u3059\u3002Invisible Column \u306e\u4ed5\u7d44\u307f\u81ea\u4f53\u306f MySQL 8.0.23 \uff082021\u5e741\u6708\uff09\u3067\u8ffd\u52a0\u3055\u308c\u305f\u3082\u306e\u3067\u3059\u3002\u5f53\u6642\u306e\u65e5\u8a18\u3092\u8aad\u307f\u8fd4\u3059\u3068\u3001\u4f7f\u3044\u9053\u304c\u3088\u304f\u308f\u304b\u3089\u306a\u3044\u3068\u8a00\u3044\u306a\u304c\u3089\u3082\u30018.0.30\u3067\u8ffd\u52a0\u3055\u308c\u305f\u6a5f\u80fd\u3068\u4f3c\u305f\u3088\u3046\u306a\u4f7f\u3044\u65b9\u3092\u60f3\u50cf\u306f\u3057\u3066\u3044\u305f\u3088\u3046\u3067\u3059\u3002\u60aa\u304f\u306a\u3044\u3002sakaik.hatebl\u2026","blog_title":"sakaik\u306e\u65e5\u3005\u96d1\u611f\uff5e(T)\u7de8","published":"2022-08-04 22:10:38","provider_url":"https://hatena.blog","url":"https://sakaik.hateblo.jp/entry/20220804/gipk_on_mysql_8030","height":"190"}