mysql - 5.5.52-MariaDB 与 5.6.15 mysql 触发器不工作

Question

我有一个问题，本地我安装了 5.6.15 mysql，这个触发器正常工作:

BEGIN

  IF New.id_category_default = 566
    THEN
      SELECT COUNT(*) DATA INTO @conta
          FROM `lorcustomization_field`
          WHERE `id_product` = Old.id_product ;

    IF @conta <=0
      THEN
        INSERT INTO `lorcustomization_field`(`id_product`,`type`,`required`)
            VALUES(Old.id_product,1,0);

    SELECT `id_customization_field` DATA INTO @idfield FROM `lorcustomization_field`
    GROUP BY `id_customization_field` DESC LIMIT 1;


    INSERT INTO `lorcustomization_field_lang` (
      `id_customization_field`,
      `id_lang`,
      `id_shop`,
      `name`
    )
    VALUES
    (
      @idfield ,
      1,
      1,
      'prova'
    );

    END IF;
  END IF;
END

我远程有 5.5.52-MariaDB，触发器在第一个输入遇到其他选择器停止时停止。我哪里错了？

Answer 1

** 改变

  SELECT COUNT(*) DATA INTO @conta
      FROM `lorcustomization_field`
      WHERE `id_product` = Old.id_product ;

IF @conta <=0
  THEN

到

IF NOT EXISTS( SELECT *
      FROM `lorcustomization_field`
      WHERE `id_product` = Old.id_product )
  THEN

** 改变

   GROUP BY `id_customization_field` DESC LIMIT 1;

到

   ORDER BY `id_customization_field` DESC LIMIT 1;

** 如果您还没有这些，请添加

INDEX(id_product)
INDEX(id_customization_field)