"Rmarkdown Rmysql"

Http://stackoverflow.com/questions/21167070/how-to-query-multiple-times-and-close-the-connection-at-the-end

Using Query1=dbsendquery (DB, "SELECT * FROM table1")

will appear

Error in Mysqlexecstatement (conn, statement, ...): RS-DBI driver: (connection with pending rows, close ResultSet before C Ontinuin

The error, solution is

Query1=dbgetquery (DB, "SELECT * FROM table1")

Because:

The function ' Dbgetquery ' does all these in one operation (submits the statement, fetches all output records, and clears t He result set).

"Rmarkdown Rmysql"