MySQL触发器不知道默认值 [英] MySQL Trigger doesn't know default value

问题描述

我使用此触发器

delimiter ||
create TRIGGER column_a_to_default 
BEFORE INSERT ON `property`
FOR EACH ROW
BEGIN  
  IF NEW.primary_image = '' THEN
    SET NEW.primary_image = default(NEW.primary_image);
  END IF;
END;
||
delimiter ;

如果我将表格插入表中，触发器将引发错误:

If I insert into the table the trigger throws an error:

字段"primary_image"没有默认值.

Field 'primary_image' doesn't have a default value.

但是可以！

这是怎么了?似乎触发器不知道默认值！

What is wrong here? It seems like the trigger isn't aware of default values!

表创建脚本

CREATE TABLE IF NOT EXISTS `property` (
  `id` varchar(10) NOT NULL,
  `images` text NOT NULL,
  `primary_image` varchar(100) NOT NULL DEFAULT '../no-image.png',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

推荐答案

default(property.primary_image)不起作用吗?

(获取Real表的默认值，而不是NEW保留表)

这篇关于MySQL触发器不知道默认值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！