Search code examples
mysqldatabaselaravelcreate-table

How do i create a table in MySql with more than 100 columns

While working on a project developed with Laravel 5.8 I wanted to create a database (table migration) with a table of more than 100 columns. So I came across this error:

Illuminate \ Database \ QueryException: SQLSTATE [42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

As I understand it, MySql cannot contain as many columns in a table.

My question is, therefore: Is there a solution to this problem?

Solution

  • Instead of using a table with a large number of columns. You can use many table and reduce the number of columns. You just have to link the table using primary and foreign keys