Results 1 to 11 of 11
Aug 25, 2012, 08:15 #1
- Join Date
- Mar 2012
- 0 Post(s)
- 0 Thread(s)
Multiple Values in One Column or Many Columns?
If I want to store and retrieve the following data in a database, what is the optimal way to do so--I am asking specifically for the "Fruits_you_like" column?
Fruits_you_like will consist of 30 different fruits. Would it be best to have one column for each fruit and use boolean 1/0 like this:
Name, Phone_Number, Email_Address, Apples, Oranges, Pears, Cherries, Strawberries
Or would it be better to only have four columns (Name, Phone_Number, Email_Address, Fruits_you_like)? If it is best to use only four columns, what should the Fruits_you_like column be? An array? Multi-dimensional array?