{"width":"100%","blog_url":"https://kwatch.hatenadiary.org/","type":"rich","author_name":"kwatch","height":"190","provider_name":"Hatena Blog","author_url":"https://blog.hatena.ne.jp/kwatch/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fkwatch.hatenadiary.org%2Fentry%2F20090204%2F1233763466\" title=\" MySQL \u3067\u306f unique key \u304c NULL \u3092\u7121\u8996\u3059\u308b - k\u306a\u3093\u3068\u304b\u306e\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>","blog_title":"k\u306a\u3093\u3068\u304b\u306e\u65e5\u8a18","categories":["db"],"provider_url":"https://hatena.blog","url":"https://kwatch.hatenadiary.org/entry/20090204/1233763466","published":"2009-02-04 01:04:26","title":" MySQL \u3067\u306f unique key \u304c NULL \u3092\u7121\u8996\u3059\u308b","image_url":null,"description":"MySQL \u3067\u306f unique key \u3092\u6307\u5b9a\u3057\u3066\u3044\u3066\u3082 NULL \u304c\u3042\u308b\u3068\u7121\u8996\u3055\u308c\u308b\u3088\u3046\u3060\u3002\u305f\u3068\u3048\u3070\u6b21\u306e\u30c6\u30fc\u30d6\u30eb\u3067\u306f\u3001name \u3068 deleted_at \u306e\u7d44\u306b unique key \u3092\u6307\u5b9a\u3057\u3066\u3044\u308b\u3002 create table test1( id integer primary key auto_increment, name varchar(100) not null, deleted_at datetime, unique key (name, deleted_at) ); \u306a\u306e\u306b\u3001\u540c\u3058\u5024\u306e\u7d44\u307f\u5408\u308f\u305b\u3092\u5165\u308c\u3066\u3082\u30a8\u30e9\u30fc\u306b\u306a\u3089\u306a\u3044\u3002 mysql> insert into test1 valu\u2026","version":"1.0"}