mysql触发器没有执行，求指导!

Question

insert,update商品数据时需要把content中只截取前8个图片tirgger语句:create trigger tri_goods_update AFTER UPDATEon ims_ewei_shop_goods for each rowbeginset @gcount = (SELECT CAST((LENGTH('content') - LENGTH(REPLACE('content',"absmiddle", ""))) / LENGTH("absmiddle") AS signed) AS count FROM ims_ewei_shop_goods where id = new.id);IF @gcount > 8 AND locate('',old.content) = 0 THENupdate ims_ewei_shop_goods set content = CONCAT(substring_index(old.content,'absmiddle',-(@gcount - 8)),'absmiddle" >') where id = new.id;END IF;END触发器创建，和修改执行后没有报错，content中的数据没有改变.

Answer 1

触发器不要更新自己会造成循环，使用navica工具看看表上触发器是否成功，内容和选项是否正确