Jari Mäkelä writes:
> It is easier to have consequential data before starting to make the > relations if you are forced to work on fixing up the follies/ages old > tables of other people True, true. What I can't understand is why so many people insist on wanting to renumber things continously. Could it be that they're trying to store some information in a column whose only purpose should be to provide rows with unique identities? I've done similar things in the past, but it's really a bad idea to refer to things by some name or number that's not guaranteed never to change. And just think of the mess you get when you decide to change the type of a column that you've used as a foreign key. It's bad enough to have to choose between the four int types. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. --------------------------------------------------------------------- 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