MySQL Primary Key.

Asked 2 years ago, Updated 2 years ago, 45 views

MySQL frequently enters and deletes a table
Using Auto Increment with Primary Key keeps increasing numbers
Later, it may become a numeric range that is not supported by the programming group Should I create a unique string from the programming team and use it as the primary key instead of Auto Increment?

What are the options in this case? Please reply.

database

2022-09-21 18:12

1 Answers

If you use Auto increment with BIGINT, we can support it up to 18446744073709551615. It takes 580,000 years to get a million inserts per second.

I don't think this will happen.

Source


2022-09-21 18:12

If you have any answers or tips


© 2024 OneMinuteCode. All rights reserved.