![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
Forrest_Gumps
路漫漫其修远兮,吾将上下而求索
展开
-
hibernate执行mysql函数或者存储过程错误定义名称
hibernate执行mysql函数或者存储过程错误定义名称org.hibernate.exception.GenericJDBCException: could not execute queryThe user specified as a definer ('xlw'@'%') does not exist原创 2016-08-19 17:27:54 · 428 阅读 · 0 评论 -
创建存储过程更新表字段
CREATE PROCEDURE updateStudent(IN intime varchar(20))BEGINDECLARE stuid int;DECLARE syear int;DECLARE b int default 0; #终止循环 declare cur cursor for select tid,student_year from ta原创 2016-10-23 17:52:01 · 1130 阅读 · 1 评论 -
mysql定时器执行存储过程
SET GLOBAL event_scheduler = 1; -- 启动定时器SET GLOBAL event_scheduler = 0; -- 停止定时器show variables like '%sche%'; create event if not exists eventJob on schedule every 15 secon原创 2016-10-23 18:19:49 · 391 阅读 · 0 评论