-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, all --
I would like to create a couple of related tables (just for starters) but I can't figure out how to do it; there are lots of CREATE TABLE examples in the mysql manual but nothing that shows related columns. For instance, I'd have a client table with name, address, etcetc, and client ID columns. Then I'd also have a room table with room listings, capacities, locations, etcetc, and room ID columns. Add to that a classes table showing info about classes offerred and, of course, a class ID column. Finally maybe an instructor table with the same sort of columns. Now I want a schedule table that will instantiate a course and track what clients are in it, using the client ID from the client table and the class ID from the class table and the room and the instructor and such. How do I specify a foreign key or a related column or a whatever when I create this table? TIA & HAND 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! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE96XHRGb7uCXufRwARAiB2AJ49zRrJWsTF/eMwwoC8I4Ao3wk9SQCfdDXY AVkqYPa71Hvj+ZPYsNyCJ5g= =zryv -----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