\u8a72\u5f53\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u7a7a\u306b\u3057\u305f\u72b6\u614b\u3067\u4ee5\u4e0b\u306eSQL\u3092\u767a\u884c\u3059\u308c\u3070\u623b\u308a\u307e\u3059\u3002<\/p>\n
ALTER TABLE `example_table` PACK_KEYS = 0 CHECKSUM = 0 DELAY_KEY_WRITE = 0 AUTO_INCREMENT = 1;<\/pre>\n\u3000InnoDB\u306e\u5834\u5408\u306f\u3001\u8d77\u52d5\u6642\u306b max \u3067 auto_increment \u306e\u5024\u3092\u3068\u3063\u3066\u3001\u30e1\u30e2\u30ea\u4e0a\u306b\u4fdd\u5b58\u3057\u3066\u304a\u3044\u3066\u756a\u53f7\u3092\u632f\u308b\u3089\u3057\u3044\u306e\u3067\u3001\u30c6\u30fc\u30d6\u30eb\u3092\u7a7a\u306b\u3057\u3066 mysqld \u3092\u518d\u8d77\u52d5\u3059\u308c\u3070\u30ea\u30bb\u30c3\u30c8\u3055\u308c\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u8a72\u5f53\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u7a7a\u306b\u3057\u305f\u72b6\u614b\u3067\u4ee5\u4e0b\u306eSQL\u3092\u767a\u884c\u3059\u308c\u3070\u623b\u308a\u307e\u3059\u3002 ALTER TABLE `example_table` PACK_KEYS = 0 CHECKSUM = 0 DELAY_KEY_WRITE = 0 AU […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[43],"tags":[7],"class_list":["post-552","post","type-post","status-publish","format-standard","hentry","category-development","tag-linux"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"MySQL\u3067auto_increment\u306e\u6570\u5024\u3092\u30ea\u30bb\u30c3\u30c8 | \u5909\u306a\u30e4\u30d0\u3044\u3082\u3093\u30ed\u30b0","description":"\u8a72\u5f53\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u7a7a\u306b\u3057\u305f\u72b6\u614b\u3067\u4ee5\u4e0b\u306eSQL\u3092\u767a\u884c\u3059\u308c\u3070\u623b\u308a\u307e\u3059\u3002 ALTER TABLE `example_t","canonical_url":"https:\/\/ecpplus.net\/weblog\/mysql%e3%81%a7auto_increment%e3%81%ae%e6%95%b0%e5%80%a4%e3%82%92%e3%83%aa%e3%82%bb%e3%83%83%e3%83%88\/","robots":"max-snippet:-1, max-image-preview:large, max-video-preview:-1","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"ja_JP","og:site_name":"\u5909\u306a\u30e4\u30d0\u3044\u3082\u3093\u30ed\u30b0","og:type":"article","og:title":"MySQL\u3067auto_increment\u306e\u6570\u5024\u3092\u30ea\u30bb\u30c3\u30c8 | \u5909\u306a\u30e4\u30d0\u3044\u3082\u3093\u30ed\u30b0","og:description":"\u8a72\u5f53\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u7a7a\u306b\u3057\u305f\u72b6\u614b\u3067\u4ee5\u4e0b\u306eSQL\u3092\u767a\u884c\u3059\u308c\u3070\u623b\u308a\u307e\u3059\u3002 ALTER TABLE `example_t","og:url":"https:\/\/ecpplus.net\/weblog\/mysql%e3%81%a7auto_increment%e3%81%ae%e6%95%b0%e5%80%a4%e3%82%92%e3%83%aa%e3%82%bb%e3%83%83%e3%83%88\/","og:image":"https:\/\/ecpplus.net\/weblog\/wp-content\/uploads\/2020\/06\/13450.jpg","og:image:secure_url":"https:\/\/ecpplus.net\/weblog\/wp-content\/uploads\/2020\/06\/13450.jpg","og:image:width":1500,"og:image:height":1500,"article:tag":["development","linux"],"article:published_time":"2008-09-02T06:46:38+00:00","article:modified_time":"2020-05-24T14:22:34+00:00","twitter:card":"summary_large_image","twitter:site":"@ecpplus","twitter:title":"MySQL\u3067auto_increment\u306e\u6570\u5024\u3092\u30ea\u30bb\u30c3\u30c8 | \u5909\u306a\u30e4\u30d0\u3044\u3082\u3093\u30ed\u30b0","twitter:description":"\u8a72\u5f53\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u7a7a\u306b\u3057\u305f\u72b6\u614b\u3067\u4ee5\u4e0b\u306eSQL\u3092\u767a\u884c\u3059\u308c\u3070\u623b\u308a\u307e\u3059\u3002 ALTER TABLE `example_t","twitter:creator":"@ecpplus","twitter:image":"https:\/\/ecpplus.net\/weblog\/wp-content\/uploads\/2021\/06\/backpack_man.jpg"},"aioseo_meta_data":{"post_id":"552","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2021-01-02 15:53:45","updated":"2022-09-29 11:54:42","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"