MySQL Forums
Forum List  »  InnoDB

Convert int primarykey to Bigint
Posted by: Sridhar Marella
Date: November 02, 2022 10:20PM

I am using mysql5.7.

We have a table which uses int field as primary key. We hit a max limit of int and not able to store new entries.

What is the fastest and safe way to resolve this problem?


TIA.

Options: ReplyQuote


Subject
Views
Written By
Posted
Convert int primarykey to Bigint
46
November 02, 2022 10:20PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.