Question

navicat 8.0 mysql中如何调用存储过程

Answer 1

CREATE DEFINER=`root`@`localhost` PROCEDURE `curdemo`()
BEGIN
DECLARE done INT DEFAULT 0;
DECLARE userid,repid INT;
DECLARE cur1 CURSOR FOR select u.userid,u.repid from user u,personalwebsite p where
p.url u.repid and p.distributorid = u.userid
and p.url = u.userid;
DECLARE CONTINUE HANDLER FOR SQLSTATE \'02000\' SET done = 1;
OPEN cur1;
REPEAT
FETCH cur1 INTO userid,repid;
IF NOT done THEN
update personalwebsite set url = repid where distributorid = userid;
END IF;
UNTIL done END REPEAT;
CLOSE cur1;
END;

Answer 2

begin
DECLARE x1 CHAR(5) DEFAULT 'outer';
Declare x2 char(5) DEFAULT 'fefff';
Declare x3 int(5) DEFAULT '34';
select x1, x2,x3;
end