Problems? Is your data what you think it is? | |
PerlMonks |
Re: OT - SQL choosing a schema for index tablesby parthodas (Acolyte) |
on Aug 28, 2015 at 07:16 UTC ( [id://1140291]=note: print w/replies, xml ) | Need Help?? |
How many fields would be there for multiple values. IF there is only one such column, then you can think of creating a different table and use Foreign Key. If the no of columns are higher, then the situation will become too complex to get a data from different tables. Also, you can insert multiple values in a column. Though it is not advisable. So it depends, depending on your situation & requirement how you plan to retrieve/fetch data.
In Section
Seekers of Perl Wisdom
|
|