mySQL存储过程循环语句

CREATE PROCEDURE `bdm721903595_db`.`test2`()
	NOT DETERMINISTIC


BEGIN
  DECLARE v1 INT DEFAULT 0;

  WHILE v1 <200 DO
    insert `uid_1_rowTitle`(`name`) values(' ');
    SET v1 = v1 + 1;
  END WHILE;

END
posted @ 2020-09-01 21:53  多弗朗强哥  阅读(224)  评论(0编辑  收藏  举报