mysql
雨夜星辰03
学无止境
展开
-
mysql报错execute command denied to user 'root'@'%' for routine
mysql报错execute command denied to user 'root'@'%' for routine执行以下sql语句即可GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' ;FLUSH PRIVILEGES;原创 2018-05-03 17:14:52 · 11771 阅读 · 0 评论 -
存储过程中遍历游标的三种方式(For,Fetch,While)
create or replace procedure myprocedure is CURSOR CUR_TEST IS --声明显式游标 SELECT ECODE,ENAME FROM EMP; CUR CUR_TEST%ROWTYPE; --定义游标变量,该变量的类型为基于游标C_EMP的记录 ...转载 2018-12-24 16:26:55 · 1667 阅读 · 0 评论