{"type":"rich","author_url":"https://blog.hatena.ne.jp/k-kurikuri/","title":"\u3010MYSQL\u3011\u526f\u554f\u3044\u5408\u308f\u305b\u306e\u7d50\u679c\u3092DELETE\u3059\u308b","height":"190","url":"https://k-kurikuri.hatenadiary.jp/entry/2018/06/07/114829","width":"100%","author_name":"k-kurikuri","published":"2018-06-07 11:48:29","provider_url":"https://hatena.blog","provider_name":"Hatena Blog","image_url":null,"blog_url":"https://k-kurikuri.hatenadiary.jp/","description":"\u305f\u307e\u306b\u3057\u304b\u4f7f\u7528\u3057\u306a\u3044\u3060\u308d\u3046\u3057\u3001\u5fd8\u308c\u308b\u81ea\u4fe1\u304c\u3042\u308b\u306e\u3067\u30e1\u30e2 # \u4f5c\u6210\u3057\u305f\u30c6\u30b9\u30c8\u30c7\u30fc\u30bf\u306etoken\u304c\u8981\u4ef6\u3092\u6e80\u305f\u3057\u3066\u306a\u3044\u306e\u3067\u3001\u62bd\u51fa\u3057\u3066\u524a\u9664\u3059\u308b\u611f\u3058 DELETE FROM user_devices WHERE user_id in ( SELECT user_id FROM ( SELECT user_id FROM user_devices WHERE CHAR_LENGTH(token) <= 200 ) as tmp )","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fk-kurikuri.hatenadiary.jp%2Fentry%2F2018%2F06%2F07%2F114829\" title=\"\u3010MYSQL\u3011\u526f\u554f\u3044\u5408\u308f\u305b\u306e\u7d50\u679c\u3092DELETE\u3059\u308b - \u6817\u30d6\" 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","blog_title":"\u6817\u30d6","categories":[]}