title: Inserting multiple rows using mysql-otp driver for erlang with mysql:query
body: <p>I'm using the mysql-otp driver for Erlang. It seems to be working fine but there is no documentation on using it to insert multiple rows into a table.</p>
  
  <p>simple use case for single row insert:</p>
  
  <pre><code>ok = mysql:query(Pid, "INSERT INTO mytable (id, bar) VALUES (?, ?)", [1, 42]).
  </code></pre>
  
  <p>But I need to insert multiple values, can I do something like this?</p>
  
  <pre><code>  ok = mysql:query(Pid, "INSERT INTO mytable (id, bar) VALUES (?, ?)", [(1, 42),(2, 36), (3,12)]).
  </code></pre>
  
  <p>Documentation states Params = [term()], so probably not, which is a bummer.</p>