navicat mysql存储过程实例_用navicat创建mysql存储过程的示例

用navicat创建mysql存储过程的示例，这个存储过程比较简单，利用了游标，循环，插入数据，更新数据等行为。代码如下：

BEGIN

DECLARE FNAME1 VARCHAR(50);

DECLARE FPATH1 VARCHAR(200) DEFAULT '0';

DECLARE FSIZE1 INT DEFAULT 0;

DECLARE FTIME1 VARCHAR(50) DEFAULT '0';

DECLARE FSTATUS1 VARCHAR(10);

DECLARE FTYPE1 VARCHAR(10);

DECLARE FNEWNAME1 VARCHAR(50);

DECLARE FEXT1 VARCHAR(20);

DECLARE FGENRE1 VARCHAR(10);

DECLARE UEMAIL1 VARCHAR(50);

DECLARE done INT DEFAULT FALSE;

DECLARE cur_file CURSOR FOR  select fname,fpath,fsize,ftime,fstatus,ftype,fnewname,fext,fgenre,uemail from tmp_files where active_flag = 'N';

DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

-- 打开游标

OPEN  cur_file;

-- 遍历

read_loop: LOOP

FETCH cur_file INTO FNAME1,FPATH1,FSIZE1,FTIME1,FSTATUS1,FTYPE1