用phpmyadmin添加不了触发器

来源：互联网发布：sqlserver varchar 编辑：程序博客网时间：2024/04/30 08:10

本来我是用navicat for mysql 在本地测试，添加触发器是OK的。

但是在服务器时我用phpmyadmin 添加，报语法错误，才知道phpmyadmin是添加不了触发器的。

改用navicat for mysql 工具就可以了

触发器语法和SQL Server有所不同，变量的赋值之类的，下面是语法案例

DROP TRIGGER IF EXISTS exam_trigger; create trigger exam_triggerafter insert on examFOR EACH ROWBEGIN DECLARE peoplecount int;DECLARE newclasssize int;DECLARE newmodifycount int;select count(*) INTO peoplecount from exam where examschool = NEW.examschool and examnum = NEW.examnum;select classsize,modifycount INTO newclasssize,newmodifycount from examschool where eschool = NEW.examschool;IF(peoplecount = newclasssize*21) THENIF(NEW.examschool='翠竹' || NEW.examschool='园岭') THENIF(newmodifycount<=1) THENupdate examschool set classsize=classsize+2,modifycount=modifycount+1 where eschool = NEW.examschool;ELSEIF(newmodifycount=2) THENupdate examschool set classsize=classsize+1,modifycount=modifycount+1 where eschool = NEW.examschool;END IF;ELSEIF(NEW.examschool='莲花北') THENIF(newmodifycount=0) THENupdate examschool set classsize=classsize+2,modifycount=modifycount+1 where eschool = NEW.examschool;ELSEIF(newmodifycount=1) THENupdate examschool set classsize=classsize+1,modifycount=modifycount+1 where eschool = NEW.examschool;END IF;ELSEIF(NEW.examschool='益田' && newmodifycount<=2) THENupdate examschool set classsize=classsize+1,modifycount=modifycount+1 where eschool = NEW.examschool;ELSEIF(NEW.examschool='景田' && newmodifycount<=4) THENupdate examschool set classsize=classsize+1,modifycount=modifycount+1 where eschool = NEW.examschool;END IF;END IF;END