DELIMITER $$ DROP PROCEDURE IF EXISTS HelloWorld$$ CREATE PROCEDURE HelloWorld () BEGIN SELECT 'Hello World'; END$$ DELIMITER; CALL HelloWorld(); DELIMITER $$ DROP PROCEDURE IF EXISTS Variable$$ CREATE PROCEDURE Variable (input_number INT) BEGIN DECLARE my_int INT; SET my_int =SQRT(input_number); select my_int; END$$ DELIMITER ; CALL Variable(100); DELIMITER $$ DROP PROCEDURE IF EXISTS discounted$$ CREATE PROCEDURE discounted (IN price NUMERIC(8,2), OUT discountPrice NUMERIC(8,2)) BEGIN IF (price >= 500.0) THEN SET discountPrice = price * 0.8; ELSEIF(price >= 100) THEN SET discountPrice = price * 0.9; ELSE SET discountPrice = price; END IF; END$$ DELIMITER ; CALL discounted(500,@newPrice); SELECT @newPrice; 使用 LOOP 和 END LOOP 字句的简单循环 当条件为真时继续执行的循环,使用 WHILE和 END WHILE 字句 循环直至条件为真,使用 REPEAT 和 UNTIL 字句 DELIMITER $$ DROP PROCEDURE IF EXISTS simple_loop$$ CREATE PROCEDURE simple_loop () BEGIN DECLARE counter INT DEFAULT 0; my_loop : LOOP SET counter = counter + 1; IF counter = 10 THEN LEAVE my_loop; END IF; END LOOP my_loop; SELECT "I can count to 10."; END$$ DELIMITER ; CALL simple_loop();
0票
开心
0票
板砖
0票
感动
0票
有用
0票
疑问
0票
难过
0票
无聊
0票
震惊
顶
踩