Home >Database >Mysql Tutorial >Sqlserver与Mysql触发器有什么差别呢?

Sqlserver与Mysql触发器有什么差别呢?

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-07 16:17:131133browse

下面显示的是触发器用到的两个表 --创建sc表CREATETABLE[sc]([ScId]intNOTNULL,[SNo]intNOTNULL,[CNo]intNOTNULL,[Score]intDEFAULTNULL,PRIMARYKEY([ScId]) ); --添加履历表CREATETABLEscore_record ( SrIdintNOTNULL, SNointNOTNULL, CNointNOTNULL, OldSc

   下面显示的是触发器用到的两个表

  --创建sc表CREATETABLE[sc]([ScId]intNOTNULL,[SNo]intNOTNULL,[CNo]intNOTNULL,[Score]intDEFAULTNULL,PRIMARYKEY([ScId])

  );

  --添加履历表CREATETABLEscore_record (

  SrIdintNOTNULL,

  SNointNOTNULL,

  CNointNOTNULL,

  OldScoreintNOTNULL,

  NewScoreintNOTNULL,

  UpdateTimedatetimeNOTNULL,PRIMARYKEY(SrId),

  );

  下面显示的是Mysql写的触发器

  --Mysql写的触发器--创建触发器,将修改前后的成绩插入到履历表DROPTRIGGERIFEXISTS`trigger_sr`;

  DELIMITER//CREATETRIGGER`trigger_sr` AFTERUPDATEON`sc`FOREACH ROWBEGININSERTINTOscore_recordSETSNo=new.SNo,

  CNo=new.CNo,

  OldScore=old.Score,

  NewScore=new.Score,

  UpdateTime=NOW() ;END//DELIMITER ;

  下面显示的是Sqlserver写的触发器

  --Sqlserver写的触发器--创建触发器,将修改前后的成绩插入到履历表CREATETRIGGERtrigger_sronscforupdateasdeclare@

  这个只是触发器之间的差别,像储存过程,自定义函数等一定还有很大的区别,不过,现在的感觉是学完一种数据库语言,,其他的数据库学起来也是那样吧。

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn