论坛 › MySQL安装|入门 › sqlserver触发器转换成mysql,求教！！

[′李大傻_ 发表于 2013-1-16 14:54:40

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:37

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

查看完整版本: sqlserver触发器转换成mysql,求教！！