Syntactic Confectionery Delight | |
PerlMonks |
Re^3: Storing multiple value field in a MySQL databaseby GrandFather (Saint) |
on Nov 25, 2013 at 19:46 UTC ( [id://1064282]=note: print w/replies, xml ) | Need Help?? |
Why? davido has illustrated the general layout of the tables for the normal solution. An alternative would be:
which is obviously dumb because of all the repeated information and the slightly more subtle problem that if jerry's age changes (age does tend to change) you have to fix every 'jerry' row. Or maybe you mean something like:
but then there is no efficient way to search for all newhires. So, again, why? What is it about davido's solution that you don't like or can't understand?
True laziness is hard work
In Section
Seekers of Perl Wisdom
|
|