I'm relatively new to MySQL and am drawing up some ideas for writing a
support/trouble tracking database for my company. I envisioned a single
database with seperate tables for various data I would be storing
(IP/Connection info table, Machine Inventory Table, etc). Each table would
have data for
First of all, search the web for a tutorial on basic SQL and database
design. There are lots out there, and most are good. It's important to work
through this stuff and get a handle on it. I believe there are good ones at
DevShed and WebMonkey.
Secondly, this is really a MySQL question and