MySQL: Error Code: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB

by

I tried all the solutions here, but only this parameter

innodb_strict_mode             = 0

solved my day…

From the manual:

The innodb_strict_mode setting affects the handling of syntax errors
for CREATE TABLE, ALTER TABLE and CREATE INDEX statements.
innodb_strict_mode also enables a record size check, so that an INSERT
or UPDATE never fails due to the record being too large for the
selected page size.

More Related Contents:

  1. how to delete data from table A besides the customer service and director data in table B?
  2. Error related to only_full_group_by when executing a query in MySql
  3. SQL split values to multiple rows
  4. Get records with max value for each group of grouped SQL results
  5. How to populate a table with a range of dates?
  6. MYSQL OR vs IN performance
  7. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  8. MySQL Cannot Add Foreign Key Constraint
  9. Grouping into interval of 5 minutes within a time range
  10. Convert timestamp to date in MySQL query
  11. Update a column value, replacing part of a string
  12. MySQL: View with Subquery in the FROM Clause Limitation
  13. MySQL/MariaDB – order by inside subquery
  14. View’s SELECT contains a subquery in the FROM clause
  15. Can MySQL replace multiple characters?
  16. OUTPUT Clause in MySQL
  17. Using ORDER BY and GROUP BY together
  18. Sorting by date & time in descending order?
  19. Difference between these two joining table approaches?
  20. MySQL Pivot Table Column Data as Rows
  21. updating columns with a sequence number mysql
  22. MySQL, Concatenate two columns
  23. Select a column with a keyword name
  24. MySQL Stored Procedures not working with SELECT (basic question)
  25. ERROR 1148: The used command is not allowed with this MySQL version
  26. Use Composite Primary Key as Foreign Key
  27. MySQL Select minimum/maximum among two (or more) given values
  28. How to select data where a field has a min value in MySQL?
  29. INSERT INTO Table from multiple tables
  30. Mysql How do you create a clustered index?

Leave a Comment