{"width":"100%","blog_url":"https://flash.hatenablog.com/","type":"rich","image_url":null,"title":"SQL\u306e\u65e5\u306b\u306a\u3063\u3066\u3057\u307e\u3063\u305f","published":"2010-05-22 07:26:11","provider_name":"Hatena Blog","description":"\u7121\u7ddaLAN\u3001DHCP\u304c\u3068\u308c\u306a\u3044\u3002\u6709\u7dda\u3067\u3084\u3063\u305f\u3002 \u91cd\u8907\u304c\u53d6\u308a\u9664\u3051\u306a\u3044 DELETE FROM papers p1 WHERE id > ( SELECT MIN(id) FROM papers p2 WHERE p1.pmid == p2.pmid AND p1.cited_pmid == p2.cited_pmid ); \u3053\u308c\u304c\u5b9f\u884c\u3067\u304d\u306a\u3044\u3002DELETE\u3067\u306f\u4f55\u304b\u306eSELECT\u3067\u4f7f\u3048\u308b\u6587\u6cd5\u304c\u4f7f\u3048\u306a\u3044\u3089\u3057\u3044\u3002 sqlite> .output noduplicate.sql sqlite> .mode insert papers sqlite> SELECT * FROM papers p1 WHE\u2026","author_url":"https://blog.hatena.ne.jp/flashingwind/","height":"190","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fflash.hatenablog.com%2Fentry%2F20100522%2F1274480771\" title=\"SQL\u306e\u65e5\u306b\u306a\u3063\u3066\u3057\u307e\u3063\u305f - \u30d7\u30ed\u30b0\u30e9\u30de\u30fc\u306b\u306a\u308a\u305f\u3044\u3002\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","version":"1.0","categories":["\u30d0\u30a4\u30c8","R"],"provider_url":"https://hatena.blog","blog_title":"\u30d7\u30ed\u30b0\u30e9\u30de\u30fc\u306b\u306a\u308a\u305f\u3044\u3002","author_name":"flashingwind","url":"https://flash.hatenablog.com/entry/20100522/1274480771"}