1, reporting the reason for the error
MySQL in strict mode, BL0B,TEXT,GEOMETRY and JSON types do not allow default values!
The error is as follows：
[Err]1101 - BLOB, TEXT, GEOMETRY or JSON column 'content' can't have a default value
2 Solution
-
Run the following SQL statement, remove the strict mode, do not need to restart mysql service, re- execute the update script.
set GLOBAL SQL _mode = 'NO_ENGINE_SUBSTITUTION'
-
View SQL _mode
show variables like 'SQL _mode'
