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
361
November 02, 2022 10:20PM


Sorry, you can't reply to this topic. It has been closed.

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.