sqlserver触发器转换成mysql,求教！！

[′李大傻_

sqlsever触发器代码如下。我刚学mysql，语法不太懂，大神求教啊！怎么改成mysql
create trigger per_delete on person
for delete
as
begin
update department
set department.num=(select COUNT(cno) from personnel
where department.sname=personnel.sname)
where department.sname in (select department.sname from deleted)
end

kider

试试 SQLWays 这个工具，或论坛里搜一下