What kind of column should this be: 10/5, 1/10, 2/50 etc.
Wondering the best one to use.
I was thinking about doing a decimal 10.5, 1.10, it doesnt matter.
Im just separating two values but want to save time by retrieving one row.
1,5 = level 1, 50 percent
4,9 = level 4, 90 percent
Thats all im doing, should I just use VARCHAR?
BTW, these are all staying under 9, so the max is 9,9
Really if it is two different pieces of information, level and percentage, then it should be different fields. Two fields of type tinyint(1) would seem to be sufficient.
Thanks I think you are right ill just do it your way so i dont confuse myself later