How to create a stored procedure in MySQL and add records in a loop

This article uses an example to describe how to create a stored procedure in MySQL and add records in a loop. Share with you for your reference, the details are as follows:

First create, then call:

-- Create stored procedure DELIMITER; //
create procedure myproc()
begin
declare num int;
set num=1;
while num <= 24 do
insert into t_calendar_hour(hourlist) values(num);
set num=num+1;
end while;
commit;
end;//
-- Call the stored procedure CALL myproc();

PS: Here are two commonly used SQL online tools for your reference (including SQL statement usage instructions):

SQL online compression/formatting tool:
http://tools.jb51.net/code/sql_format_compress

SQL code online formatting and beautification tool:
http://tools.jb51.net/code/sqlcodeformat

Readers who are interested in more MySQL-related content can check out the following topics on this site: "MySQL stored procedure skills", "MySQL common function summary", "MySQL log operation skills", "MySQL transaction operation skills summary" and "MySQL database lock related skills summary"

I hope this article will be helpful to everyone's MySQL database design.