Don't ask to ask, just ask | |
PerlMonks |
Re: Re: Re: Yet Another Half Perl Half mySQL Questionby eejack (Hermit) |
on Jul 06, 2001 at 23:15 UTC ( [id://94566]=note: print w/replies, xml ) | Need Help?? |
I would tend to agree with you, but you really only need the two tables if the assumption is a one to many relationship.
But assuming a many to many relationship your schema is nicer, and certainly if you expand the scope, having an id on both the ip address and name is a good thing (most probably a necessary thing). One minor point though, you can still do reverse lookups on my schema: But thanks for pointing out a nicer way of doing it than I did. Thanks, EEjack
In Section
Seekers of Perl Wisdom
|
|