Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How many columns can you have (maximum) in a MySQL table?

Tags:

mysql

What's the max number of columns a mysql table can have?

like image 380
Ali Avatar asked Nov 11 '09 04:11

Ali


1 Answers

According to the MySQL Reference Manual, there is a "hard limit" of 4,096 columns per table.

Check the following link for more information.

like image 182
Edward Avatar answered Sep 29 '22 09:09

Edward