Because that's the way that (FoxPro, Access, Paradox, insert name of favorite desktop RDBMS here) did it and I can't make the jump to a real server based RDBMS!
Why do you ask? :) Seriously, I find this type of issue (not your question Paul, the original question) one of the most troubling things about this list. We as a community of SQL developers (regardless of dialect) need to make a more concentrated effort to explain the differences between desktop databases and real database engines. We need to educate people making the changeover before releasing them into the wild. (Maybe the link to download MySql could ask a few basic questions to prove you know what you are doing before being allowed to download!) :) I cut my teeth on FoxPro. The first SQL I wrote was in the FoxPro (2.5/6?) dialect. I know from whence I speak because I asked these same questions many years ago. Luckily, I found people who kindly but firmly pointed me in the right direction. ("You DON'T need gapless sequences for PK's." "You DON'T store images in the actual database without permission from God." "Here's the FAQ we developed so you don't have to waste our time asking questions that have already been answered." "Thank you, come again.") They showed me the light and occasionally I try to share what little I know with others. I guess what I'm trying to say is to those who know something (even if you are like me and are constantly amazed at what you DON'T know) share kindly and willingly. To those seeking enlightenment...RTFM you mook! Check the !*#&^ archives and use Google, this issue has been beat to death! Humbly, =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -----Original Message----- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 29, 2002 10:02 AM To: Adam Wi´ckowski; [EMAIL PROTECTED] Subject: Re: An Idea Why? --------------------------------------------------------------------- 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