Maximum Number of columns in MySQL table [duplicate]

Question

I'm fairly new to MySQL. I have a few questions:

1) How many (maximum) no. of columns can be created in a MySQL Table.

2) How many (maximum) no. of tables can be created in a MySQL database.

Answer 1

• 1- Approximately 4,096 columns per table.

• 2-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.

Answer 2

You can find precise information here :

• Maximum no. of columns
• Maximum no. of tables

In a nutshell:

• 4096 columns per table, 1017 with InnoDB
• No limit on the number of tables, 4 billion with InnoDB