A case study of MySQL creating stored procedures and cycling to add records
This article will explain in detail the case study of creating stored procedures and cyclically adding records in MySQL. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.
Create first, and then call:
-- create a stored procedure DELIMITER;//create procedure myproc () begindeclare num int;set num=1;while num