reason
MySQL stipulates that default values are not allowed for blob, text, geometry and JSON data types. In this example, the content field is not set with a default value. After analysis, it is determined whether it is the reason for not null, so the content field is set to null
Solution:
Delete not null in the table creation statement
Similar Posts:
- used in key specification without a key length
- Solution of data truncated for column ‘xxx’ in MySQL
- [Solved] cannot load from mysql.proc. the table is probably corrupted
- Python TypeError: __init__() missing 1 required positional argument: ‘on_delete’
- [Solved] MySQL uses the workbench tool, and the table status is read only
- When mysql creates a table, set timestamp DEFAULT NULL error 1067-Invalid default value for’updated_at’
- [Solved] MySQL Add New Field Error: ERROR 1118 — Row size too large. The maximum row size for the used table type
- [Solved] SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘vod_content’.
- Error in importing excel file from SQL Server
- MySQL exclude error 1114 holmium HY000 41 holmium“