I have a database (Engine
InnoDB) that was setup by someone else. I noticed that one column contains data between 1 and 107 at this moment, and it is highly unlikely to further increase much.
As it is currently set up as
INT my idea was to change type to
Can I just do that without losing data? What would be the most efficient way to go about it?
I am still rather new to databases, getting my hands dirty at the moment and learning all about data types and performance, etc. Looks like my precursor hasn't done such a good job... :(