How many tables we can create in mysql data base? is there any limit in number of tables in MYSQL database?
3
-
May be he/she is not aware of Stackoverflow procedure. You have to approve the answer from the user once you satisfied with the answer and it works for you.samir chauhan– samir chauhan2011-11-04 06:03:24 +00:00Commented Nov 4, 2011 at 6:03
-
"More than you'll ever need" ... and if you need more than a few dozen (on a small-medium project), then red-flags should likely start going off.user166390– user1663902011-11-04 06:08:21 +00:00Commented Nov 4, 2011 at 6:08
-
@magicmike See link above. I find it easiest just to copy'n'paste it ;-)user166390– user1663902011-11-04 06:29:21 +00:00Commented Nov 4, 2011 at 6:29
Add a comment
|
1 Answer
MySql has no limit on the number of databases, though your underlying filesystem may impose limitations that practically limit the number of tables in a MySQL database.
MySQL has no limit on the number of databases. The underlying file system may have a limit on the number of tables. Individual storage engines may impose engine-specific constraints. InnoDB [only] permits up to 4 billion tables.
