MYSQL 触发器 报错

[zhang8771889]

create trigger trigger_update_delivery after insert on
mid_delivery_order2
for each row
begin
UPDATE mid_delivery_order2 u1
JOIN (
select t1.id, t1.psdh,t1.hisspbm,t1.scph from mid_delivery_order2 t1 group by t1.psdh,t1.hisspbm,t1.scph having count(*)>1
)T2 ON T2.id = u1.id
SET u1.scph = CONCAT('*',u1.scph)
WHERE 1
end;



----报错

[SQL] create trigger trigger_update_delivery after insert on
mid_delivery_order2
for each row
begin
UPDATE mid_delivery_order2 u1
JOIN (
select t1.id, t1.psdh,t1.hisspbm,t1.scph from mid_delivery_order2 t1 group by t1.psdh,t1.hisspbm,t1.scph having count(*)>1
)T2 ON T2.id = u1.id
SET u1.scph = CONCAT('*',u1.scph)
WHERE 1
end;

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'end' at line 11

[卖水果的net]

SET u1.scph = CONCAT('*',u1.scph) WHERE 1 ; -- 条件后，要写一个分号 end;

[风暴偷鸡队]

错误提示很清楚啊，语法错误，第11行end关键字附近

[RINK_1]

DELIMITER $ create trigger trigger_update_delivery after insert on mid_delivery_order2 for each row begin UPDATE mid_delivery_order2 u1 JOIN ( select t1.id, t1.psdh,t1.hisspbm,t1.scph from mid_delivery_order2 t1 group by t1.psdh,t1.hisspbm,t1.scph having count(*)>1 )T2 ON T2.id = u1.id SET u1.scph = CONCAT('*',u1.scph) WHERE 1 ; end $ DELIMITER ;