Firebird execute block 批处理

https://www.cnblogs.com/jonney-wang/p/9350974.html

execute block as
declare variable i int = 0;
begin
while(:i < 100) do
begin
:i = :i + 1;
insert into m_user(code) values('shang hai' || :i);
end
end

posted @ 2022-04-04 11:02  81  阅读(69)  评论(0编辑  收藏  举报