mysql - for循环在sql语句中重复20次

Question

我在下面使用但出现错误，这段代码有什么问题:

declare  
begin  
for i in 1..20  
loop  
execute immediate 'update table IMP_BACKUP set name='XYZ' where status='INVALID'';  
end loop;  
end;  
/

Answer 1

将变量 i 声明为

declare
  i number(2);
begin
for i in 1..20 loop 
  execute immediate 'update table IMP_BACKUP set name=''XYZ'' where   status=''INVALID''';  
end loop;  
end;  
/