{"id":401,"date":"2008-11-22T22:33:00","date_gmt":"2008-11-22T13:33:00","guid":{"rendered":"http:\/\/www.code-life.jp\/blog\/archives\/401"},"modified":"2010-07-25T10:26:49","modified_gmt":"2010-07-25T01:26:49","slug":"%e6%ad%af%e6%8a%9c%e3%81%91%e3%81%ae%e6%9c%80%e5%b0%8f%e5%80%a4%e3%82%92%e6%8e%a2%e3%81%99","status":"publish","type":"post","link":"https:\/\/www.code-life.jp\/blog\/2008\/11\/22\/%e6%ad%af%e6%8a%9c%e3%81%91%e3%81%ae%e6%9c%80%e5%b0%8f%e5%80%a4%e3%82%92%e6%8e%a2%e3%81%99\/","title":{"rendered":"\u6b6f\u629c\u3051\u306e\u6700\u5c0f\u5024\u3092\u63a2\u3059"},"content":{"rendered":"<p><a href=\"http:\/\/codezine.jp\/article\/detail\/1269\">\u5206\u6790\u95a2\u6570\u306e\u885d\u6483\uff08\u524d\u7de8\uff09<\/a>\u3067\u3059\u3067\u306b\u7b54\u3048\u306f\u51fa\u3066\u3044\u308b\u306e\u3060\u3051\u308c\u3069\u3001\u540c\u3058\u7d50\u679c\u304c\u62bd\u51fa\u3067\u304d\u308b\u30af\u30a8\u30ea\u3092\u4f5c\u3063\u3066\u3057\u307e\u3063\u305f\u306e\u3067\u3001\u30e1\u30e2\u3002<\/p>\n<pre class=\"program\"><code>select min(id + 1) as gap\r\nfrom (\r\n  select 0 as id\r\n  union\r\n  select id\r\n  from tablename\r\n) as dummy\r\nwhere id + 1 not in (\r\n  select id\r\n  from tablename\r\n);<\/code><\/pre>\n<p>MySQL\u3067\u52d5\u4f5c\u691c\u8a3c\u6e08\u307f\u3002<\/p>\n<p>(1, 2, 3, 4, 5)\u306e\u3046\u3061\u3001(3)\u304c\u629c\u3051\u3066(1, 2, 4, 5)\u3068\u306a\u3063\u3066\u3044\u308b\u5834\u5408\u306f\u3001(3)\u304c\u53d6\u5f97\u3067\u304d\u308b\u3002<\/p>\n<p>(1, 2, 3, 4, 5)\u306e\u3046\u3061\u3001(1)\u304c\u629c\u3051\u3066(2, 3, 4, 5)\u3068\u306a\u3063\u3066\u3044\u308b\u5834\u5408\u306f\u3001\u3061\u3083\u3093\u3068(1)\u304c\u53d6\u5f97\u3067\u304d\u308b\u3002<\/p>\n<p>(1, 2, 3, 4, 5)\u306e\u3044\u305a\u308c\u3082\u629c\u3051\u304c\u306a\u3051\u308c\u3070\u3001(6)\u304c\u8fd4\u5374\u3055\u308c\u308b\u3002<\/p>\n<p>\u3061\u306a\u307f\u306b\u3001(1, 2, 3, 4, 5)\u306e\u3044\u305a\u308c\u3082\u629c\u3051\u304c\u306a\u3044\u5834\u5408\u306bnull\u3092\u8fd4\u5374\u3059\u308b\u3088\u3046\u306b\u3057\u305f\u3044\u5834\u5408\u306f\u3001where\u7bc0\u306b&#8221; id + 1 &lt;= 5&#8243;\u3092\u8ffd\u52a0\u3059\u308b\u3002<\/p>\n<pre class=\"program\"><code>select min(id + 1) as gap\r\nfrom (\r\n  select 0 as id\r\n  union\r\n  select id\r\n  from tablename\r\n) as dummy\r\nwhere id + 1 not in (\r\n  select id\r\n  from tablename\r\n)<strong> and id + 1 &lt;= 5<\/strong>;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u5206\u6790\u95a2\u6570\u306e\u885d\u6483\uff08\u524d\u7de8\uff09\u3067\u3059\u3067\u306b\u7b54\u3048\u306f\u51fa\u3066\u3044\u308b\u306e\u3060\u3051\u308c\u3069\u3001\u540c\u3058\u7d50\u679c\u304c\u62bd\u51fa\u3067\u304d\u308b\u30af\u30a8\u30ea\u3092\u4f5c\u3063\u3066\u3057\u307e\u3063\u305f\u306e\u3067\u3001\u30e1\u30e2\u3002 select min(id + 1) as gap from ( select 0 as id union &hellip; <a class=\"more-link\" href=\"https:\/\/www.code-life.jp\/blog\/2008\/11\/22\/%e6%ad%af%e6%8a%9c%e3%81%91%e3%81%ae%e6%9c%80%e5%b0%8f%e5%80%a4%e3%82%92%e6%8e%a2%e3%81%99\/\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"screen-reader-text\">\u6b6f\u629c\u3051\u306e\u6700\u5c0f\u5024\u3092\u63a2\u3059<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[11],"tags":[],"_links":{"self":[{"href":"https:\/\/www.code-life.jp\/blog\/wp-json\/wp\/v2\/posts\/401"}],"collection":[{"href":"https:\/\/www.code-life.jp\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.code-life.jp\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.code-life.jp\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.code-life.jp\/blog\/wp-json\/wp\/v2\/comments?post=401"}],"version-history":[{"count":3,"href":"https:\/\/www.code-life.jp\/blog\/wp-json\/wp\/v2\/posts\/401\/revisions"}],"predecessor-version":[{"id":568,"href":"https:\/\/www.code-life.jp\/blog\/wp-json\/wp\/v2\/posts\/401\/revisions\/568"}],"wp:attachment":[{"href":"https:\/\/www.code-life.jp\/blog\/wp-json\/wp\/v2\/media?parent=401"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.code-life.jp\/blog\/wp-json\/wp\/v2\/categories?post=401"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.code-life.jp\/blog\/wp-json\/wp\/v2\/tags?post=401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}