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
