with adoquery1 do
begin
SQL.Add('Insert into tablename (name,class,score) Value (a1,b1,c1)');
SQL.Add('Insert into tablename (name,class,score) Value (a2,b2,c2)');
SQL.Add('Insert into tablename (name,class,score) Value (a3,b3,c3)');
ExecSQL;
end;
begin
SQL.Add('Insert into tablename (name,class,score) Value (a1,b1,c1)');
SQL.Add('Insert into tablename (name,class,score) Value (a2,b2,c2)');
SQL.Add('Insert into tablename (name,class,score) Value (a3,b3,c3)');
ExecSQL;
end;
“Insert into tablename select name,class,score from table where 条件;”实现!