{"id":5747,"date":"2015-04-12T00:08:11","date_gmt":"2015-04-11T15:08:11","guid":{"rendered":"http:\/\/www.webcyou.com\/?p=5747"},"modified":"2015-04-12T00:14:05","modified_gmt":"2015-04-11T15:14:05","slug":"mysql-%e3%82%aa%e3%83%bc%e3%83%88%e3%82%a4%e3%83%b3%e3%82%af%e3%83%aa%e3%83%a1%e3%83%b3%e3%83%88%e3%81%ae%e5%80%a4%e3%82%92%e3%83%aa%e3%82%bb%e3%83%83%e3%83%88","status":"publish","type":"post","link":"https:\/\/www.webcyou.com\/?p=5747","title":{"rendered":"MySQL \u30aa\u30fc\u30c8\u30a4\u30f3\u30af\u30ea\u30e1\u30f3\u30c8\u306e\u5024\u3092\u30ea\u30bb\u30c3\u30c8"},"content":{"rendered":"<p>\u5fd8\u308c\u306a\u3044\u3088\u3046\u306b\u3068\u3002<\/p>\n<p><a href=\"https:\/\/www-jp.mysql.com\/\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.webcyou.com\/wp-content\/uploads\/a385eb251304726e8ecdea6178069abd.png\" alt=\"\" title=\"\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8 2015-04-12 0.13.07\" width=\"121\" height=\"74\" class=\"alignnone size-full wp-image-5750\" \/><\/a><\/p>\n<p><strong>MySQL\u306e\u30aa\u30fc\u30c8\u30a4\u30f3\u30af\u30ea\u30e1\u30f3\u30c8\u306e\u5024\u3092\u30ea\u30bb\u30c3\u30c8<\/strong>\u3059\u308b\u30b3\u30de\u30f3\u30c9\u306f\u3002<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">ALTER TABLE '\u30c6\u30fc\u30d6\u30eb\u540d' AUTO_INCREMENT = \u6b21\u306e\u756a\u53f7\u306b\u3057\u305f\u3044\u6570\u5024;<\/pre>\n<\/p>\n<p>id\u306a\u3069\u81ea\u52d5\u7684\u306b\u5897\u3048\u308b\u3088\u3046\u306b\u30aa\u30fc\u30c8\u30a4\u30f3\u30af\u30ea\u30e1\u30f3\u30c8\u3092\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u304c\u591a\u3005\u3067\u3001id\u306e\u30ab\u30e9\u30e0\u304c\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u3066<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">id=1,2,3,4,5,6,7<\/pre>\n<\/p>\n<p><strong>id\u300c5,6,7\u300d\u3092\u524a\u9664<\/strong>\u3057\u305f\u3068\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">id=1,2,3,4<\/pre>\n<\/p>\n<p>\u305d\u308c\u3067\u3001<strong>\u65b0\u305f\u306b\u884c\u3092\u8ffd\u52a0\u3057\u305f\u969b\u3001id\u306f\u300c5\u300d\u306b\u306a\u3063\u3066\u6b32\u3057\u3044<\/strong>\u3068\u3053\u308d\u3067\u3059\u304c<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">id=1,2,3,4,8<\/pre>\n<\/p>\n<p>\u3053\u3093\u306a\u611f\u3058\u3067\u524a\u9664\u3057\u305f\u30ab\u30e9\u30e0\u306e<strong>\u30aa\u30fc\u30c8\u30a4\u30f3\u30af\u30ea\u30e1\u30f3\u30c8\u306e\u5024\u306f\u4fdd\u6301\u3055\u308c\u305f\u307e\u307e\u3001id\u306f\u6b21\u306e\u5024<\/strong>\u3068\u306a\u3063\u3066\u3057\u307e\u3057\u307e\u3059\u3002<\/p>\n<p>\u305d\u3053\u3067\u3001\u524a\u9664\u3057\u305f\u5f8c\u3001\u5192\u982d\u306e\u30b3\u30de\u30f3\u30c9\u3067\u5024\u306e\u5909\u66f4\u3092\u3002<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">id=1,2,3,4,5,6,7<\/pre>\n<\/p>\n<p>\u2193 <strong>\u524a\u9664<\/strong><\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">id=1,2,3,4<\/pre>\n<\/p>\n<p>\u2193 <strong>\u5909\u66f4<\/strong><\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">ALTER TABLE `\u30c6\u30fc\u30d6\u30eb\u540d` AUTO_INCREMENT = \u6b21\u306e\u756a\u53f7\u306b\u3057\u305f\u3044\u6570\u5024;<\/pre>\n<\/p>\n<p>\u2193 <strong>\u8ffd\u52a0<\/strong><\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">id=1,2,3,4,5<\/pre>\n<\/p>\n<p>\u3068\u3044\u3063\u305f\u5177\u5408\u306b\u3002<\/p>\n<h4>\u3046\u307e\u304f\u3044\u304b\u306a\u3044\u5834\u5408<\/h4>\n<p>\u4e0a\u8a18\u306e\u65b9\u6cd5\u3067\u884c\u3063\u3066\u3082\u3046\u307e\u304f\u3044\u304b\u306a\u304b\u3063\u305f\u308a\u3057\u307e\u3059\u3002<\/p>\n<p>\u305d\u306e\u969b\u306f\u3001<strong>\u524a\u9664\u3057\u305f\u5f8c\u3001AUTO_INCREMENT\u306e\u8a2d\u5b9a\u3092\u4e00\u5ea6\u5916\u3059\u3068<\/strong>\u3046\u307e\u304f\u3044\u304d\u307e\u3059\u3002<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">id=1,2,3,4,5,6,7<\/pre>\n<\/p>\n<p>\u2193 <strong>\u524a\u9664<\/strong><\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">id=1,2,3,4<\/pre>\n<\/p>\n<p>\u2193\u00a0<strong>AUTO_INCREMENT\u306e\u8a2d\u5b9a\u3092\u89e3\u9664<\/strong><\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">ALTER\u00a0TABLE\u00a0`\u30c6\u30fc\u30d6\u30eb\u540d`\u00a0CHANGE\u00a0`id`\u00a0`id`\u00a0INT\u00a0NOT\u00a0NULL;<\/pre>\n<\/p>\n<p>\u2193 <strong>\u5909\u66f4<\/strong><\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">ALTER TABLE\u00a0`\u30c6\u30fc\u30d6\u30eb\u540d`\u00a0AUTO_INCREMENT = \u6b21\u306e\u756a\u53f7\u306b\u3057\u305f\u3044\u6570\u5024;<\/pre>\n<\/p>\n<p>\u2193 <strong>\u518d\u5ea6\u00a0AUTO_INCREMENT\u306e\u8a2d\u5b9a<\/strong><\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">ALTER\u00a0TABLE\u00a0`\u30c6\u30fc\u30d6\u30eb\u540d`\u00a0CHANGE\u00a0`id`\u00a0`id`\u00a0INT\u00a0NOT\u00a0NULL\u00a0AUTO_INCREMENT;<\/pre>\n<\/p>\n<p>\u2193 <strong>\u5909\u66f4<\/strong><\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">ALTER TABLE\u00a0`\u30c6\u30fc\u30d6\u30eb\u540d`\u00a0AUTO_INCREMENT = \u6b21\u306e\u756a\u53f7\u306b\u3057\u305f\u3044\u6570\u5024;<\/pre>\n<\/p>\n<p>\u2193 <strong>\u8ffd\u52a0<\/strong><\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">id=1,2,3,4,5<\/pre>\n<\/p>\n<p>\u3068\u3053\u306e\u65b9\u6cd5\u3067\u89e3\u6c7a\u3057\u307e\u3057\u305f\u3002<\/p>\n<p>\u5fd8\u308c\u306a\u3044\u3088\u3046\u306b\u3068\u30e1\u30e2\u306a\u611f\u3058\u3067\u3057\u305f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5fd8\u308c\u306a\u3044\u3088\u3046\u306b\u3068\u3002 MySQL\u306e\u30aa\u30fc\u30c8\u30a4\u30f3\u30af\u30ea\u30e1\u30f3\u30c8\u306e\u5024\u3092\u30ea\u30bb\u30c3\u30c8\u3059\u308b\u30b3\u30de\u30f3\u30c9\u306f\u3002 ALTER TABLE &#8216;\u30c6\u30fc\u30d6\u30eb\u540d&#8217; AUTO_INCREMENT = \u6b21\u306e\u756a\u53f7\u306b\u3057\u305f\u3044\u6570\u5024; id\u306a\u3069\u81ea\u52d5\u7684\u306b\u5897\u3048\u308b\u3088\u3046\u306b\u30aa\u30fc\u30c8\u30a4\u30f3 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[35],"tags":[166,37,47,107,180,173,150],"class_list":["post-5747","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-iphone","tag-iphone-","tag-javascript-2","tag-mamp","tag-mysql","tag-php","tag-vagrant"],"_links":{"self":[{"href":"https:\/\/www.webcyou.com\/index.php?rest_route=\/wp\/v2\/posts\/5747","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webcyou.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webcyou.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webcyou.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webcyou.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5747"}],"version-history":[{"count":4,"href":"https:\/\/www.webcyou.com\/index.php?rest_route=\/wp\/v2\/posts\/5747\/revisions"}],"predecessor-version":[{"id":5749,"href":"https:\/\/www.webcyou.com\/index.php?rest_route=\/wp\/v2\/posts\/5747\/revisions\/5749"}],"wp:attachment":[{"href":"https:\/\/www.webcyou.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5747"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webcyou.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5747"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webcyou.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5747"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}