result-meta

0th

Percentile

Database interface meta-data.

See documentation of generics for more details.

Usage
# S4 method for MySQLResult
dbColumnInfo(res, ...)

# S4 method for MySQLResult dbGetRowsAffected(res, ...)

# S4 method for MySQLResult dbGetRowCount(res, ...)

# S4 method for MySQLResult dbHasCompleted(res, ...)

# S4 method for MySQLResult dbGetException(conn, ...)

# S4 method for MySQLResult summary(object, verbose = FALSE, ...)

# S4 method for MySQLResult show(object)

Arguments
res,conn,object

An object of class '>MySQLResult

...

Ignored. Needed for compatibility with generic

verbose

If TRUE, print extra information.

Aliases
  • dbColumnInfo,MySQLResult-method
  • dbGetException,MySQLResult-method
  • dbGetRowCount,MySQLResult-method
  • dbGetRowsAffected,MySQLResult-method
  • dbHasCompleted,MySQLResult-method
  • result-meta
  • show,MySQLResult-method
  • summary,MySQLResult-method
Examples
# NOT RUN {
if (mysqlHasDefault()) {
con <- dbConnect(RMySQL::MySQL(), dbname = "test")
dbWriteTable(con, "t1", datasets::USArrests, overwrite = TRUE)

rs <- dbSendQuery(con, "SELECT * FROM t1 WHERE UrbanPop >= 80")
dbGetStatement(rs)
dbHasCompleted(rs)

dbGetInfo(rs)
dbColumnInfo(rs)

dbClearResult(rs)
dbRemoveTable(con, "t1")
dbDisconnect(con)
}
# }
Documentation reproduced from package RMySQL, version 0.10.16, License: GPL-2

Community examples

Looks like there are no examples yet.