SQL format types | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

SQL format types

What if I need to store intervals like 5-10 or 100-500? What kind of type should I use? And another one is how to store values like 5*108, 5/108? Should I use string format? Thanks

12th Sep 2021, 10:02 PM
Denis Kolesnikov
Denis Kolesnikov - avatar
1 Answer
+ 2
Denis Kolesnikov Yes in this case you should use VARCHAR otherwise make 3 columns for each value for example: minValue, Seperator, maxValue. But I think 1 column is enough which will be String format
13th Sep 2021, 1:48 AM
A͢J
A͢J - avatar