* Inbal Ovadia > Is there any limitation about the number of rows in a table > and about the number of tables that i can put in mysql?
The number of rows in a table is normally limited by the type of the primary key. A TINYINT can only hold 256 values, thus you can only have 256 rows in a table with a TINYINT primary key. The 'normal' (?) datatype for a primary key is INT, a 32 bit integer. This datatype can hold 4294967295 different values, but you will probably not be able to create this number of rows because of OS limitations. A table can also be created without a primary key, then the number of rows is only limited by the OS file size limit. There are a couple of options to get around the OS file size limits: using MERGE tables (merging multiple identical structured tables) or InnoDb tables (multiple table spaces.) The number of tables is limited by the OS only, roughly speaking we can say that you can have as many tables as the OS can have files... :) -- Roger query --------------------------------------------------------------------- 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
