S
S
sampapa2016-04-28 09:51:05
MySQL
sampapa, 2016-04-28 09:51:05

How to fix ID assignment in MySQL?

In phpmyadmin, I manually changed the article ID in the xxxx_content table. I imported articles from the old site, but to avoid problems, I assigned long numbers to new articles - articles ID 4294967295 turned out.
31f083d058fc431cbeaf1d6a1dab536f.png3b1f0564d61d4d2aa53584b0d04beaa5.png
Questions:
1. What do I need to fix so that the numbering goes from a different number, and not from 4294967295? What file to go to?
2. What do you need and where to register so that the newly created articles on the site are assigned the ID of already deleted articles? And it turns out that by deleting the article we lose the ID

Answer the question

In order to leave comments, you need to log in

2 answer(s)
S
sampapa, 2016-04-29
@sampapa

Everything, I figured it out. In the table - Operations has changed data in the column
In the picture - now the data has changed
46419a6ec5f349f8bcb1891734d12b28.png

E
Evgeny Bukharev, 2016-04-28
@evgenybuckharev

In theory, this is how it should be, by deleting the article, the id should be deleted accordingly, since there are situations when other tables refer to this one to a specific id, for example, if the article has tags or categories, in your case it is possible that a new article will be reference data that does not belong to it. And you can reset the autoincrement value in the column settings

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question