摘要: 游标取值越界时,利用标志来结束mysql curson中,可以declare continue hander来操作越界标志declare continue handler create procedure p16() begin declare row_gid int; declare row_nu 阅读全文
posted @ 2019-06-03 16:46 yahn~ 阅读(128) 评论(0) 推荐(0) 编辑
摘要: 更新 mysql> create trigger t2 -> after -> insert on ord -> for each row -> begin update goods set num=num-new.mch where gid = new.gid; -> end$Query OK, 阅读全文
posted @ 2019-06-03 08:06 yahn~ 阅读(100) 评论(0) 推荐(0) 编辑