RMySQL (version 0.10.2)

result-meta: Database interface meta-data.

Description

See documentation of generics for more details.

Usage

## S3 method for class 'MySQLResult':
dbColumnInfo(res, ...)
## S3 method for class 'MySQLResult':
dbGetRowsAffected(res, ...)
## S3 method for class 'MySQLResult':
dbGetRowCount(res, ...)
## S3 method for class 'MySQLResult':
dbHasCompleted(res, ...)
## S3 method for class 'MySQLResult':
dbGetException(conn, ...)
## S3 method for class 'MySQLResult':
summary(object, verbose = FALSE, ...)
## S3 method for class 'MySQLResult':
show(object)

Arguments

res,conn,object

An object of class MySQLResult

...

Ignored. Needed for compatibility with generic

verbose

If TRUE, print extra information.

Examples

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)
}