title: how to close resultset in RMySQL?
body: <p>I used RMySQL for import database, sometimes when I try to close the connection, I receive the following error:</p>
  
  <pre><code>Error in mysqlCloseConnection(conn, ...) : 
    connection has pending rows (close open results set first)
  </code></pre>
  
  <p>I have no other ways of correcting this other than restarting the computer, anything I can do so solve this? Thanks!</p>