title: RODBC - multiple statements in one sqlQuery() call
body: <p>In R, I'm getting an error whenever I pass a query with multiple statements to sqlQuery.
  For example,</p>
  
  <pre><code>sqlQuery(ch, 'DROP TABLE IF EXISTS t1; DROP TABLE IF EXISTS t2;')
  </code></pre>
  
  <p>produces the error</p>
  
  <pre><code>[1] "42000 1064 [MySQL][ODBC 5.1 Driver][mysqld-5.5.27]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP TABLE IF EXISTS t2' at line 1"
  [2] "[RODBC] ERROR: Could not SQLExecDirect 'DROP TABLE IF EXISTS t1; DROP TABLE IF EXISTS t2;'"
  </code></pre>
  
  <p>What am I doing wrong?</p>