Hi again,
I've been given a better solution (wow you guys are speedy!), which is to
use an application_os junction table, which is the thing I was missing . .
. I was thinking of the junction table wrong, Thanks! If anyone has any
other suggestions, they will be appreciated, it's just that once I saw the
obvious answer, I wanted to stem the flow of those.
Thanks,
Chip
At 09:01 AM 7/17/01 -0400, you wrote:
>Hi all,
>I'm fairly new to MySQL and to SQL in general, but not a complete
>newbie. I have the o'reilly book, as well as dubois and the SAMS PHP &
>MySQL books . . . I think I know the answer to the question but I want to
>make sure I'm not missing anything
>
>I'm building a database that will list application vulnerabilities tied to
>ports and OS's
>and I'm ending up with a many-to-many relationship with the applications
>-> OS's section
>
>for example:
>application X -> NT3, NT4 SP1, NT4 SP2
>
>building a cross product style table of all OS combinations is
>impractical, therefore I think that I just need to create some multiple
>(say 10) of the OS fields, and enter them that way
>
>+-------------------------+
>| app | os1 | os2 | os3|
>+-------------------------+
>| app x | 1 | 3 | 4 |
>+-------------------------+
>
>where the numbers in the OS column are the primary key from the OS table
>
>granted, this isn't elegant, but I think it should work, am I missing
>anything?
>
>Thanks,
>Chip
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
