Sample Header Ad - 728x90

Do I lose data if I change from INT to TINYINT

0 votes
1 answer
5148 views
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 TINYINT unsigned. 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... :(
Asked by Kolja (363 rep)
Dec 30, 2014, 07:50 PM
Last activity: Dec 31, 2014, 04:27 PM