MySQL - 報錯 Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT ( error 1118 ) 解決方法
Published in:2023-01-19 | category: MySQL


解決方法: 關閉 mysql 嚴格模式



查看 innodb_strict_mode 參數是否為 on

show variables like '%innodb_strict_mode%';


關閉嚴格模式:

vim /etc/my.cnf
[mysqld] >> innodb_strict_mode: 0


登入 mysql 後查看設定 OFF

show variables like '%innodb_strict_mode%';



Prev:
MySQL - 主從報錯 Error 'Duplicate entry 'XXXXX' for key 'XXX'' on query. ( error 1062 ) 解決方法
Next:
MySQL - 主從報錯 Table 'mysql.gtid_slave_pos' doesn't exist in engine ( error 1932 ) 解決方法