- 0
MySQL Change primary on a large table
-
Recently Browsing 0 members
- No registered users viewing this page.
-
Similar Content
-
Distributed SQL: The architecture behind MariaDB Xpand — Free Whitepaper
By News Staff,
- ebook offer
- sponsored
- (and 4 more)
- 0 replies
- 6 views
-
- 0 replies
- 7 views
-
- 8 replies
- 1,942 views
-
Save 96% off a lifetime plan to iBrave Cloud Web Hosting — or alternative deal
By News Staff,
- ibrave
- web hosting
- (and 9 more)
- 0 replies
- 4 views
-
Save 96% off a lifetime subscription to iBrave Cloud Web Hosting + $20 Store Credit
By News Staff,
- ibrave
- neowin deals
- (and 9 more)
- 0 replies
- 5 views
-
Question
SuperKid
Hi,
I need some advice and help, I need to change the primary key ID to auto increment on a table which is 19.4GB in size with approximately 150 million entries.
Apparently running Alter table is going to take hours and hours to complete which I can understand.
The table has huge amounts of data in it
What would be the fastest way to update the items table?
Link to comment
Share on other sites
5 answers to this question
Recommended Posts