Hi.
On Wed 2002-06-05 at 14:21:03 -0500, [EMAIL PROTECTED] wrote:
> In the last episode (Jun 05), Pooja Daryani said:
>
> > > I need to know how many rows are supported in mysql db.
>
> If there is a limit, it's probably 4294967296 rows. But you'll
> never get that many in a table anyway.
:-)
Due to interest I tried to look it up in the manual and did not found
such a number, until it occured to me, that regarding the underlying
structure of the database files, there is probably no row limit, but
only a file size limit (by data pointer size).
So the number of rows would be MAXSIZE / average_row_length and that
is quite a lot (as the newer versions support 64Bit pointers).
Bye,
Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
