SitePoint Sponsor |
|
User Tag List
Results 1 to 3 of 3
-
Nov 29, 2009, 03:12 #1
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
etc..
Thats all im doing, should I just use VARCHAR?
BTW, these are all staying under 9, so the max is 9,9
-
Nov 29, 2009, 04:01 #2
- Join Date
- Jun 2007
- Location
- North Yorkshire, UK
- Posts
- 483
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
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.
-
Nov 30, 2009, 04:15 #3
Thanks I think you are right ill just do it your way so i dont confuse myself later
Bookmarks