DROP PROCEDURE
IF
EXISTS test_insert;
DELIMITER;;
CREATE PROCEDURE test_insert ( ) BEGIN
DECLARE
i INT DEFAULT 1;
WHILE
i < 100 DO
SELECT
123 AS 'name'
SET i = i + 1;
END WHILE;
COMMIT;
END;;
CALL test_insert ( );
mysql实现for循环
最新推荐文章于 2024-05-25 10:43:53 发布