>Monday, October 28, 2002, 2:00:28 PM, you wrote:
>
>MS> At 13:36 +0200 28-10-2002, Victoria Reznichenko wrote:
> >>MdB> 2) How many entries can one single table have?
>>>MdB> (The absolute maximum)
>>>
>>>There are no limits on number of rows.
>
>MS> What if the values for Primary Key run out?
>
>You get "Duplicate key" error.
>
>MS> Can you use a unsigned bigint as Primary Key?
>
>MS> I mean, we /have/ to store the properties of sandgrains in the Sahara
>*somewhere*, right :-)
>
>The maximum unsigned bigint value is not the same as "limits on number of rows", is
>it?
Hey, you tell me, I'm just a MySQL newbie :-)
Just wondering if there exists a theoretical maximum, even if no one will ever reach
it, it'd be good ammo in the preferred-dbserver-wars
"My database can hold a larger infinite number of rows than your database!"
;-)
Regards,
Martin
--
<mailto:mac.com@;nemo>
<http://www.mechintosh.com/>
---------------------------------------------------------------------
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
