文章浏览阅读5.5k次。CREATE trigger updatetbl_slopeAFTER update-- 表示触发器是在激活它的语句之后触发on tbl_slopefor each row – mysql固定语法BEGINif EXISTS(SELECT * FROM checkupdates A WHERE A.ID=new.UNIFIEDCODE LIMIT 1)THENupdate checkupdates set LastTime=NOW() wher......
目录创建触发器删除触发器查看触发器创建触发器create trigger 触发器名触发时刻触发事件on表名for each row 动作;create trigger tr_log_stu_in after insert on stu for each rowinsert into log values (.....);create trigger tr_log_stu_up after update on stu for each rowin......
1.查询数据库中的存储过程和函数方法一:select `name` from mysql.proc where db = 'your_db_name' and `type` = 'PROCEDURE' //存储过程select `name` from mysql.proc where db = 'your_db_name' and `type` = 'FUNCTION' //函数方..._native怎么看存储过程...
