'Conversion of foreign/primary key from int to bigint in SQL

I have two SQL tables where there is a foreign key ID of type int and references a second table's SID primary key column - also an int.

I fill these tables from the C++ code where I have some wrappers to do for that reason.

Now, I want to change the datatype from int to bigint in the database, because I am going to store bigger integers here (bigger than maximum of int). Obviously, I'll read these integers from the database as well.

Is it safe to do so? Are there any hidden consequences?

mysql sql

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'Conversion of foreign/primary key from int to bigint in SQL

Sources

Related Questions