mysql - MYSQL存储过程中if else

Question

给定的插入查询在我的程序中非常庞大。给定不同条件的所有插入查询都非常相同。如何准备循环以避免每次都给出插入查询而不是一次。

begin
insert query(..........)
elseif dayofmonth(now()) = 12 then
insert query(..........)
elseif dayofmonth(now()) = 22 then
insert query(..........)
endif;
end

我需要这样的程序，

begin
if dayofmonth(now()) = 2 then
elseif dayofmonth(now()) = 12 then
elseif dayofmonth(now()) = 22 then
????
insert query(........)
how to end this???

谁能帮帮我？提前致谢..

Answer 1

这样试试

begin

if dayofmonth(now()) = 6 then
SET @query="columnnames and values"
elseif dayofmonth(now()) = 12 then
SET @query="columnnames and values"
elseif dayofmonth(now()) = 22 then
SET @query="columnnames and values"
endif;

SET @query=concat("insert into", @query)
PREPARE stmt1 FROM @query; 
EXECUTE stmt1;

end