MySQL NULL 字段在 INSERT 时请求值

Question

Mysql版本:5.7.x

查询:

INSERT INTO `products_manufacturer`
   SET    `website_id` = 27,
          `name` = 'YAZAKI CORP',
          `url` = 'http://www.speclocator.com/mfg_category.php?manufacturename=YAZAKI+CORP',
          `enabled` = true,
          `rectified_manufacturer_id` = NULL,
          `logo` = NULL;

错误代码:1364。字段“facebook”没有默认值 0.000 秒

表结构附为屏幕截图。

Answer 1

插入数据后尝试以下查询

ALTER TABLE products_manufacturer MODIFY COLUMN facebook VARCHAR(255) NULL DEFAULT '0.000';