求教创建触发器

[jack_wang0823]

表结构描述
suppliersset 供应商表 sysId 是 id
contacts 联系人表 groupSysId 是suppliersset.sysId
建立一个触发器 在删除一个供应商记录时 删除 此供应商的所有联系人

create trigger delecontacts 
after delete on suppliersset
for each row
begin
delete from contacts  where contacts.groupSysId = old.sysId;
end$

提示5行错误
#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 '' at line 5

[zjcxc]

最前面加一句 delimiter $

[Rotel-刘志东]

delimiter$
create trigger delecontacts 
after delete on suppliersset
for each row
begin
delete from contacts  where contacts.groupSysId = old.sysId;
end$