title: Delphi TAdoQuery - Multiple Inserts?
body: <p>Is it possible with a Delphi TAdoQuery to execute multiple inserts in one go, or do you have to execute each statement separately? What I want to do is this:</p>
  
  <pre><code>AdoQuery.SQL.Clear;
  AdoQuery.SQL.Add('INSERT INTO user VALUES (1, "User 1");');
  AdoQuery.SQL.Add('INSERT INTO user VALUES (2, "User 2");');
  AdoQuery.SQL.Add('INSERT INTO user VALUES (3, "User 3");');
  AdoQuery.ExecSQL;   
  AdoQuery.Close;
  </code></pre>
  
  <p>Is this possible? I'm getting an error from MySQL when executing this. I also tried adding BEGIN; and END; around the queries, but that didn't work either.</p>
  
  <p>Edit: I want to do this because when I execute the inserts in a for loop it seems like it takes a really long time for > 10 queries. I'm assuming adding them all like above would speed things up. Does anyone know if the AdoQuery.Close call is necessary between inserts?</p>