title: How to do an insert with multiple rows in Informix SQL?
body: <p>I want to insert multiple rows with a single insert statement.</p>
  
  <p>The following code inserts one row, and works fine:</p>
  
  <pre><code>create temp table mytmptable
  (external_id char(10),
  int_id integer,
  cost_amount decimal(10,2)
  ) with no log;
  
  insert into mytmptable values 
  ('7662', 232, 297.26);
  
  select * from mytmptable;
  </code></pre>
  
  <p>I've tried changing the insert to this, but it gives a syntax error:</p>
  
  <pre><code>insert into mytmptable values 
  ('7662', 232, 297.26),
  ('7662', 232, 297.26);
  </code></pre>
  
  <p>Is there a way to get it working, or do I need to run many inserts instead?</p>