This method involves discarding unnecessary data and starting from the latest data. In essence, it is a minor adjustment to the numbering system. There are rare cases where verification is required. Careful attention is required when operating the command line (SQL) as it directly affects the database (incorrect operation is not permitted).<\/p>\n\n\n\n
ALTER<\/span> <\/span>TABLE<\/span> tbl_a AUTO_INCREMENT <\/span>=<\/span> <\/span>16<\/span>;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\nThis is for when you want to delete numbers 16 and above from the database and start numbering again from 16. If you don’t know the latest number, you can write it like this.<\/p>\n\n\n\n
SELECT<\/span> <\/span>MAX<\/span>(id) <\/span>AS<\/span> max_id_a <\/span>FROM<\/span> tbl_a;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\nThe above is a method for obtaining the current maximum value from the latest ID.<\/p>\n\n\n\n
max_id_a\uff1a31<\/span><\/span><\/code><\/pre><\/div>\n\n\n\nIf 31 is returned, add “+1” as shown below and execute with 32.<\/p>\n\n\n\n
ALTER<\/span> <\/span>TABLE<\/span> tbl_a AUTO_INCREMENT <\/span>=<\/span> <\/span>32<\/span>;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\nIt is also acceptable to add “+1” to the current maximum value as shown below.<\/p>\n\n\n\n
SELECT<\/span> <\/span>IFNULL<\/span>(<\/span>MAX<\/span>(id) <\/span>+<\/span> <\/span>1<\/span>, <\/span>1<\/span>) <\/span>AS<\/span> next_id <\/span>FROM<\/span> tbl_a;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\nThis is a measure to prevent unnecessary empty slots. Adjusting values in anticipation of future numbering may facilitate data management. Verification is required.<\/p>\n\n\n\n
MySQL\/MariaDB compatible. Other RDBs (e.g. PostgreSQL) need conversion.<\/p>\n","protected":false},"excerpt":{"rendered":"
This method involves discarding unnecessary data and starting from the latest data. In essence, it is a minor adjustment to the numbering system. There are rare cases where verification is required. Careful attention is required when operating the command line (SQL) as it directly affects the database (incorrect operation is not permitted). This is for […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_locale":"en_US","_original_post":"https:\/\/touhyo.com\/blog\/?p=731","footnotes":""},"categories":[1],"tags":[],"class_list":["post-738","post","type-post","status-publish","format-standard","hentry","category-memo","en-US"],"_links":{"self":[{"href":"https:\/\/touhyo.com\/blog\/wp-json\/wp\/v2\/posts\/738","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/touhyo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/touhyo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/touhyo.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/touhyo.com\/blog\/wp-json\/wp\/v2\/comments?post=738"}],"version-history":[{"count":17,"href":"https:\/\/touhyo.com\/blog\/wp-json\/wp\/v2\/posts\/738\/revisions"}],"predecessor-version":[{"id":1032,"href":"https:\/\/touhyo.com\/blog\/wp-json\/wp\/v2\/posts\/738\/revisions\/1032"}],"wp:attachment":[{"href":"https:\/\/touhyo.com\/blog\/wp-json\/wp\/v2\/media?parent=738"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/touhyo.com\/blog\/wp-json\/wp\/v2\/categories?post=738"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/touhyo.com\/blog\/wp-json\/wp\/v2\/tags?post=738"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}