当前位置：网站首页>BLOB, TEXT, GEOMETRY or JSON column 'xxxx' can't have a default value

BLOB, TEXT, GEOMETRY or JSON column 'xxxx' can't have a default value

2022-08-08 08:04:00 【industrious sloth】

Execution statement prompt: 1101 - BLOB, TEXT, GEOMETRY or JSON column 'enclosure' can't have a default value
insert image description here
Online solutions generally say either remove strict mode, or comment out or clear sql_mode
insert image description here

Insert image description here
A variety of testing attempts just didn't work

strong>
Check the new features of MySQL, the type of the field is json, the length cannot be set, it can be NULL but cannot have a default value
It can be changed to null, so that the laterModify the code by yourself

ALTER TABLE biz_cost_expense ADD enclosure json DEFAULT null COMMENT 'Attachment';ALTER TABLE biz_income_expense ADD enclosure json DEFAULT null COMMENT 'attachment';
原网站

版权声明
本文为[industrious sloth]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/220/202208080749048187.html

边栏推荐

猜你喜欢

随机推荐