{"id":155,"date":"2013-10-20T00:00:00","date_gmt":"2013-10-19T15:00:00","guid":{"rendered":"http:\/\/taitan916.info\/blog\/?p=155"},"modified":"2014-05-22T20:47:32","modified_gmt":"2014-05-22T11:47:32","slug":"post-155","status":"publish","type":"post","link":"https:\/\/taitan916.info\/blog\/archives\/155","title":{"rendered":"MySQL\u3067\u6b6f\u629c\u3051\u306b\u306a\u3063\u3066\u3044\u308bint\u578b\u306e\u6570\u5024\u3092\u53d6\u5f97\u3059\u308b"},"content":{"rendered":"<p><a class=\"keyword\" href=\"http:\/\/d.hatena.ne.jp\/keyword\/MySQL\">MySQL<\/a>\u3067\u6b6f\u629c\u3051\u306b\u306a\u3063\u3066\u3044\u308b\u30b7\u30fc\u30b1\u30f3\u30b9\u756a\u53f7\u3092<br \/>\n\u53d6\u5f97\u3057\u305f\u3044\u30b1\u30fc\u30b9\u304c\u3042\u3063\u305f\u3002<\/p>\n<p><span style=\"color: #008800;\">\u25a0\u30bd\u30fc\u30b9<\/span><br \/>\nSELECT MIN(seq + 1) AS min_no<br \/>\nFROM test_table a<br \/>\nWHERE NOT EXISTS (<br \/>\nSELECT seq<br \/>\nFROM test_table b<br \/>\nWHERE a.seq + 1 = b.seq<br \/>\n)<\/p>\n<p><span style=\"color: #008800;\">\u25a0\u53c2\u8003\u30b5\u30a4\u30c8<\/span><br \/>\n<a href=\"http:\/\/okwave.jp\/qa\/q6093210.html\">http:\/\/okwave.jp\/qa\/q6093210.html<\/a><\/p>\n<p><span style=\"color: #008800;\">\u25a0\u305d\u306e\u4ed6<\/span><br \/>\nEXISTS\u3066\u4f55\uff1f\u3000\u3068\u306a\u3063\u305f\u306e\u3067\u8abf\u3079\u305f\u3068\u3053\u308d\u3001<br \/>\n<span style=\"color: #cc0000;\">\u7d50\u679c\u304c\u5b58\u5728\u3059\u308b\u304b\u8abf\u3079\u308b<\/span>\u3001\u3068\u3044\u3046\u3082\u306e\u3089\u3057\u3044\u3002<\/p>\n<p><a href=\"http:\/\/www.i2kt.com\/dbms\/sqlref\/operator\/logic\/sql_02030501.html\">http:\/\/www.i2kt.com\/dbms\/sqlref\/operator\/logic\/sql_02030501.html<\/a><\/p>\n<p>NOT\u304c\u3064\u3044\u3066\u3044\u308b\u304b\u3089\u3001\u629c\u3051\u756a\u304c\u3042\u3063\u305f\u969b\u306b<br \/>\n\u771f\u306b\u306a\u3063\u3066\u3001\u305d\u306e\u629c\u3051\u756a\u304c\u62bd\u51fa\u3055\u308c\u3066\u3044\u308b\u307f\u305f\u3044\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL\u3067\u6b6f\u629c\u3051\u306b\u306a\u3063\u3066\u3044\u308b\u30b7\u30fc\u30b1\u30f3\u30b9\u756a\u53f7\u3092 \u53d6\u5f97\u3057\u305f\u3044\u30b1\u30fc\u30b9\u304c\u3042\u3063\u305f\u3002 \u25a0\u30bd ... <\/p>\n","protected":false},"author":1,"featured_media":1072,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-155","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts\/155","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/comments?post=155"}],"version-history":[{"count":0,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts\/155\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/media\/1072"}],"wp:attachment":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/media?parent=155"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/categories?post=155"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/tags?post=155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}