How does AUTO_INCREMENT behave, for example, when transferring a database?

If id skips are found in the database, are the values ​​recalculated during the transfer? Indeed, in this case, all the addresses of user pages will change.

Is it true to bind an address to such an ID?
Or do you need to create a separate field for this?

  • mysqldump copies as is . that is, as it is. .... there will be lines in the dump Insert into table (id, col1, col2, col3) values (1, 'val1', 'val2', 'val3'), (55, 'val1', 'val2', 'val3'), (99, 'val1', 'val2', 'val3') - Alexey Shimansky
  • @ Alexey Shimansky, in general, is this approach correct in the formation of page addresses? - Andrei Dinevich
  • one
    What is this? Well, the whole world uses as an identifier pages / user / news / articles / etc. id - Alexey Shimansky
  • one
    Notice, even this page has id 680533. Although questions are often deleted and data can be transferred between centers. Nitsche, lives still) - Alexey Shimansky
  • one
    How does AUTO_INCREMENT behave, for example, when transferring a database? It behaves exactly as specified by the code / settings of the means of transport. Half of these tools will leave the ID unchanged, the other half will certainly change all the values ​​(if some do not change, this is just a coincidence of the old and the new values). - Akina

0