Hello World之MySQL存储过程版:
Java代码
DELIMITER $
DROP PROCEDURE IF EXISTS HelloWorld$
CREATE PROCEDURE HelloWorld()
BEGIN
SELECT "Hello World!";
END$
DELIMITER ;
DELIMITER $
DROP PROCEDURE IF EXISTS HelloWorld$
CREATE PROCEDURE HelloWorld()
BEGIN
SELECT "Hello World!";
END$
DELIMITER ;
OK,调用一下:
Java代码
CALL HelloWorld();
CALL HelloWorld();
结果:
Java代码
+--------------------+
| Hello World! |
+--------------------+
| Hello World! |
+--------------------+
MySQL存储过程之Hello World
最新推荐文章于 2022-05-02 21:59:49 发布