sql - How many tables can be created in a mysql database?

Question

How many tables can be created in a mysql database ?

And how many columns can be created in a mysql table ?

How many rows can be inserted into a mysql table ?

Answer 1

How many tables can be created 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 permits up to 4 billion tables.

And how many columns can be created in a mysql table ?

There is a hard limit of 4096 columns per table, but the effective maximum may be less for a given table. The exact limit depends on several interacting factors.

How many rows can be inserted into a mysql table ?

The number of rows is limited by the maximum size allowed for a table. This is OS-dependent. You can impose a limit on the number of rows by setting MAX_ROWS at table creation time.

Reference: Limits in MySQL