{"title":"MySQL  SEQUENCE  iBATIS3 \u3067\u3002\u3002\u3002","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Foboe2uran.hatenablog.com%2Fentry%2F2010%2F10%2F30%2F120508\" title=\"MySQL  SEQUENCE  iBATIS3 \u3067\u3002\u3002\u3002 - Oboe\u5439\u304d\u30d7\u30ed\u30b0\u30e9\u30de\u306e\u9ed9\u793a\u9332\" 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":"Oboe\u5439\u304d\u30d7\u30ed\u30b0\u30e9\u30de\u306e\u9ed9\u793a\u9332","provider_name":"Hatena Blog","description":"MySQL \u3067\u3001Oracle SEQUENCE \u3068\u540c\u69d8\u306e\u6a5f\u80fd\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5\u306f\u3001\u30cd\u30c3\u30c8\u3067\u591a\u304f\u7d39\u4ecb\u3055\u308c\u3066\u308b\u3002 FUNCTION \u3092\u7528\u610f\u3057\u3066iBATIS3(myBatis) \u3067\u30b7\u30fc\u30b1\u30f3\u30b9\u5024\u53d6\u5f97\u3092\u6574\u7406\u3057\u305f\u3002 MySQL \u30b7\u30fc\u30b1\u30f3\u30b9\u306e\u4ee3\u7528\u30c6\u30fc\u30d6\u30eb\u3092\u7528\u610f CREATE TABLE sequence (id INT UNSIGNED NOT NULL); \uff11\u884c\u4f5c\u6210\u3057\u3066\u304a\u304f\u3002 INSERT INTO sequence VALUES (0); \u30d5\u30a1\u30f3\u30af\u30b7\u30e7\u30f3\u3092\u7528\u610f\u3059\u308b CREATE FUNCTION nextSequence() RETURNS INT BEGIN UPDATE sequence SET id=\u2026","categories":[],"provider_url":"https://hatena.blog","blog_url":"https://oboe2uran.hatenablog.com/","author_name":"posturan","url":"https://oboe2uran.hatenablog.com/entry/2010/10/30/120508","width":"100%","published":"2010-10-30 12:05:08","image_url":null,"height":"190","type":"rich","version":"1.0","author_url":"https://blog.hatena.ne.jp/posturan/"}