tags:

views:

79

answers:

2

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

+2  A: 

Here is a resource.

http://dev.mysql.com/doc/refman/5.0/en/column-count-limit.html

Daniel A. White
+1  A: 

Approximately 4,096 columns per table.

loyalpenguin
Not necessarily true. Depends on the datatype.
Daniel A. White