mysql - how to close resultset in RMySQL?

Question

I used RMySQL for import database, sometimes when I try to close the connection, I receive the following error:

Error in mysqlCloseConnection(conn, ...) : 
  connection has pending rows (close open results set first)

I have no other ways of correcting this other than restarting the computer, anything I can do so solve this? Thanks!

question from:https://stackoverflow.com/questions/4084028/how-to-close-resultset-in-rmysql

Answer 1

We can use the method dbClearResult.
Example:

dbClearResult(dbListResults(conn)[[1]])