> > From: David T-G <[EMAIL PROTECTED]> > Date: 2003/11/28 Fri PM 03:49:17 CST > To: mysql users <[EMAIL PROTECTED]> > CC: [EMAIL PROTECTED] > Subject: Re: Please analyze my project table design > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hi! > > ...and then [EMAIL PROTECTED] said... > % > ... > % I don't know of a DB theory rule that says it's a bad idea to have the same > columns in many tables, but it might make the design more compact to take the common > stuff and put it into one table. > > Oh, there is, indeed. CF "normalization" :-)
Well of course, but that begs the question, which normal form? > > > HTH & HAND & good luck Paul > > :-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://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.0.7 (FreeBSD) > > iD8DBQE/x8LcGb7uCXufRwARAq2vAKCDgl6tAoZyQMxRcuweK4fPFO8flQCfT1QU > pJXdxLO02cnospbngiqMqzI= > =eKBn > -----END PGP SIGNATURE----- > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]