Maximum Number of columns in MySQL table
mysql
Solution
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.
Problem
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.