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.