Arthur, et al -- ...and then Arthur Fuller said... % % I don't know about anyone else, but for this sort of thing I love the % program called DeZign, which is a data-modeling tool. You can "draw" your % tables and their columns and set up relations and so on. DeZign will then % write your code for you.
Thanks! I actually broke out a Windows box to try it out so that I could see how it would relate keys :-) Now I have some sample syntax for foreign keys, if nothing else. Anyone know of a design tool which runs on Linux and FreeBSD? % % Personally, I like to keep all my "drop" statements in one script, all my % "create" scripts in another, and all my "populate" scripts in yet another. Yeah, I think I'll do something like that. % % Arthur Thanks & HAND & Happy Holidays mysql query, :-D -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health" http://www.justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! --------------------------------------------------------------------- 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
