MYSQL 触发器 报错
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