The maximum number of columns in a MySQL table

Question

I am new to MySQL. I have a few questions:

1) How much (maximum) is not. columns can be created in a MySQL table.

2) How much (maximum) is not. tables can be created in a MySQL database.

Answer 1

• 1- Approximately 4096 columns per table.

• 2-mySQL has a limit on the number of databases. The underlying file system may have a limit on the number of tables. Separate storage engines can set engine-specific restrictions. InnoDB allows up to 4 billion tables.

Answer 2

Here you can find the exact information:

• The maximum number. the columns
• The maximum number. tables

In a nutshell:

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