CREATE DEFINER=`root`@`%` PROCEDURE `addRoomPrice`()
begin
declare i int default 0;
set i = 0;
start transaction
;
while i < 31 do
-- insert sql
insert into date_time(id, day_year, day_date,create_by,create_date,update_by,update_date,del_flag)
value (REPLACE(UUID(),'-',''),'2023', date_sub('2023-12-01', interval -i day),'1', now(), '1',now(),'0');
set i = i + 1;
end while;
commit;
end
调用即可