标题: sqlserver触发器转换成mysql,求教！！ [打印本页] 作者: [′李大傻_ 时间: 2013-1-16 14:54 标题: 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 时间: 2013-1-17 10:34
试试 SQLWays 这个工具，或论坛里搜一下