设置字段的属性和是否允许空值
ALTER TABLE specifications MODIFY type json NOT NULL;
设置json字段的默认值为空
ALTER TABLE specifications ALTER type SET DEFAULT ( JSON_OBJECT() );
https://geeksww.com/tutorials/database_management_systems/mysql/administration/default-values-for-mysql-json-columns.php
网友评论