å¨åå¨è¿ç¨ä¸å¸¸çå°declareå®ä¹çåéå@setå®ä¹çåéãç®åçæ¥è¯´ï¼declareå®ä¹ç类似æ¯å±é¨åéï¼@setå®ä¹ç类似å
¨å±åéã
1ãdeclareå®ä¹çåé类似javaç±»ä¸çå±é¨åéï¼ä»
å¨ç±»ä¸çæãå³åªå¨åå¨è¿ç¨ä¸çbeginåendä¹é´çæã
2ã@setå®ä¹çåéï¼å«åä¼è¯åéï¼ä¹å«ç¨æ·å®ä¹åéï¼å¨æ´ä¸ªä¼è¯ä¸é½èµ·ä½ç¨(æ¯å¦æ个åºç¨çä¸ä¸ªè¿æ¥è¿ç¨ä¸)ï¼å³è¿ä¸ªåéå¯ä»¥å¨è¢«è°ç¨çåå¨è¿ç¨æè
代ç ä¹é´å
±äº«æ°æ®ãå¦ä½ç解å¢ï¼å¯ä»¥çä¸é¢è¿ä¸ªç®åä¾åï¼å¾å¥½ç解ã
ï¼1ï¼å
æ§è¡ä¸é¢èæ¬ï¼å建ä¸ä¸ªåå¨è¿ç¨ï¼åå«ædeclareå½¢å¼çåéå@setå½¢å¼çåé
DROP PROCEDURE IF EXISTS temp;
DELIMITER //
CREATE PROCEDURE temp()
BEGIN
DECLARE a INT DEFAULT 1;
SET a=a+1;
SET @b=@b+1;
SELECT a,@b;
END
//
DELIMITER ;
ï¼2ï¼æ¥ç为båéåå§åã
SET @b=1;
ï¼3ï¼ç¶åéå¤è°ç¨è¿ä¸ªåå¨è¿ç¨ã
CALL temp();
ï¼4ï¼ä¼åç°açå¼ä¸æ¹åï¼èbçå¼ä¼ä¸ç´å¢å ã
æ以ï¼æ»ç»èµ·æ¥å°±æ¯å¼å¤´é£å¥è¯ï¼declareå®ä¹ç类似æ¯å±é¨åéï¼@setå®ä¹ç类似å
¨å±åéã
温馨提示:答案为网友推荐,仅供参考