title: ExecuteScalar multiple transactions
body: <p>I am trying to execute ExecuteScalar() with 2 instruction with ODBC connection to mysql in a query. My query is : </p>
  
  <pre><code>string query = @"SET @MY_ID := (SELECT IFNULL(MAX(id) + 1, 1) FROM sc);" + Environment.NewLine + "INSERT INTO sc (id, name) values (@MY_ID, 'TESTE');"
  </code></pre>
  
  <p>I am getting: </p>
  
  <p><code>{System.Data.Odbc.OdbcException (0x80131937): ERROR [42000] [MySQL][ODBC 5.1 Driver]
  [mysqld-5.0.83-community-nt]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 
  'INSERT INTO</code></p>