mysql 存储过程
DROP PROCEDURE IF EXISTS `Test_Procedure01`; DELIMITER $$ CREATE PROCEDURE `Test_Procedure01`() BEGIN -- 定义变量 DECLARE v_i int unsigned DEFAULT 0; WHILE v_i < 5 DO SELECT v_i; SET v_i = v_i 1; END WHILE; END $$ DELIMITER ; call Test_Procedure01();
温馨提示: 本文由Jm博客推荐，转载请保留链接: https://www.jmwww.net/SQL/12562.html
- 上一篇：mysql存储过程
- 下一篇：mysql锁机制详解
