{"image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/n/nainaistar/20251231/20251231211301.png","height":"190","categories":["MySQL","DB","\u6280\u8853"],"version":"1.0","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fnainaistar.hatenablog.com%2Fentry%2Fcanot-setup-master-data-in-mysql\" title=\"MySQL\u3067\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\u3067\u304d\u306a\u3044\u30de\u30b9\u30bf\u30c7\u30fc\u30bf\u304c\u3042\u3063\u305f - \u304d\u308a\u4e38\u306e\u6280\u8853\u65e5\u8a18\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","type":"rich","provider_url":"https://hatena.blog","url":"https://nainaistar.hatenablog.com/entry/canot-setup-master-data-in-mysql","author_name":"nainaistar","description":"\u59cb\u3081\u306b \u4e00\u90e8\u306e\u81ea\u52d5\u30c6\u30b9\u30c8\u304c\u66f8\u304b\u308c\u3066\u3044\u306a\u3044\u72b6\u6cc1\u3060\u3063\u305f\u305f\u3081\u3001\u30c6\u30b9\u30c8\u30b1\u30fc\u30b9\u3092\u62e1\u5145\u3057\u3088\u3046\u3068\u3057\u3066\u3044\u307e\u3057\u305f\u3002\u3057\u304b\u3057\u3001\u30c6\u30b9\u30c8\u3092\u66f8\u304f\u904e\u7a0b\u3067\u30c9\u30cf\u30de\u308a\u3057\u305f\u5185\u5bb9\u304c\u3042\u3063\u305f\u305f\u3081\u30d6\u30ed\u30b0\u306b\u3057\u307e\u3059\u3002 \u74b0\u5883 MySQL 8.0.40 Python 3.13 SQLAlchemy 2.0.40 \u4e8b\u8c61 \u30de\u30b9\u30bf\u30c7\u30fc\u30bf\u304c\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\u3067\u304d\u306a\u3044\u3002id=0\u306e\u30c7\u30fc\u30bf\u304c\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\u3055\u308c\u306a\u3044\u3002 \u8a73\u7d30 MySQL\u306e\u4ed5\u69d8\u3067SQLMode\u306bNO_AUTO_VALUE_ON_ZERO\u304c\u7121\u3044\u3068AUTOINCREMENT\u5217\u306e 0 \u306f NULL \u3068\u540c\u3058\u6271\u3044\u306b\u306a\u308a\u63a1\u756a\u3055\u308c\u308b Upsert\u3067\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\u3057\u3066\u3044\u305f\u306e\u3067\u3001id=0\u304cid=1\u3068\u3057\u3066\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\u3055\u308c\u308b id\u2026","provider_name":"Hatena Blog","author_url":"https://blog.hatena.ne.jp/nainaistar/","published":"2026-01-05 12:00:00","blog_title":"\u304d\u308a\u4e38\u306e\u6280\u8853\u65e5\u8a18","width":"100%","blog_url":"https://nainaistar.hatenablog.com/","title":"MySQL\u3067\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\u3067\u304d\u306a\u3044\u30de\u30b9\u30bf\u30c7\u30fc\u30bf\u304c\u3042\u3063\u305f"}