-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, all --
I'm finally jumping into playing with mysql, and talking to it with perl, and I find that even though I did well in classes years ago in school I really have no idea what I'm doing :-) I've been working up the script to simply parse my data (unique path names to tracks containing items like artist, album, and so on) and am currently storing it in a hash just to do something with it. I'll write that subroutine later once I have an idea of where I'm going -- which I hardly do at this point! I think I have the idea of table relations down, but I could probably use some more help. I've read most of the tutorial at mysql.com (gonna finish tomorrow!) and get how to create a database and create a table and such but don't really see anything that will help me figure out *how* to lay out the database. I realize that there are doubtless as many ways to design a particular database as there are to do anything else, but certainly there must be some "best practice" theory out there, preferably on the 'net somewhere where I can get to it instead of only in a bookstore. This particular case is storage of MP3 data for my collection. I have a number of parameters regarding each file and I think I've sorted them out into three or four tables, but don't have the design fleshed out yet, and certainly don't know if I might want to add more to it later. One certainly has to draw a line in the sand somewhere, so only so much planning can be done before it's time to get moving and implement. Once you have a database, though, can you add to or modify the structure, including the relations, or are you stuck with what you have until you export the data somehow and import it into a new structure? I could go on and on :-) about this particular project, but I don't want to bore folks with what are probably very basic questions. I should go off and do my homework first, but I need to know where to find the material. TIA & HAND :-D - -- David T-G * It's easier to fight for one's principles (play) [EMAIL PROTECTED] * than to live up to them. -- fortune cookie (work) [EMAIL PROTECTED] http://www.justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9B5VbGb7uCXufRwARAmeJAKCW6KxmEuGfFllJlXnuOk5SI0maZACfXD7+ IEDdSPyv5RnKBiq3Gjxgf/U= =//Fr -----END PGP SIGNATURE----- --------------------------------------------------------------------- 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