MySQL :: MySQL 5.0 Reference Manual :: D.7.4 Limits on Table Column Count and Row Size
There is a hard limit of 4096 columns per table, but the effective maximum may be less for a given table. The exact limit depends on several interacting ... Each table has an .frm file that contains the table definition. The definition affects the content...