MySQLResult-class {RMySQL}R Documentation

Class MySQLResult

Description

MySQL's query results class. This classes encapsulates the result of an SQL statement (either select or not).

Generators

The main generator is dbSendQuery.

Extends

Class "DBIResult", directly. Class "MySQLObject", directly. Class "DBIObject", by class "DBIResult". Class "dbObjectId", by class "MySQLObject".

Methods

coerce
signature(from = "MySQLConnection", to = "MySQLResult"): ...
dbClearResult
signature(res = "MySQLResult"): ...
dbColumnInfo
signature(res = "MySQLResult"): ...
dbGetException
signature(conn = "MySQLResult"): ...
dbGetInfo
signature(dbObj = "MySQLResult"): ...
dbGetRowCount
signature(res = "MySQLResult"): ...
dbGetRowsAffected
signature(res = "MySQLResult"): ...
dbGetStatement
signature(res = "MySQLResult"): ...
dbHasCompleted
signature(res = "MySQLResult"): ...
dbListFields
signature(conn = "MySQLResult", name = "missing"): ...
fetch
signature(res = "MySQLResult", n = "numeric"): ...
fetch
signature(res = "MySQLResult", n = "missing"): ...
summary
signature(object = "MySQLResult"): ...

References

See the Database Interface definition document DBI.pdf in the base directory of this package or http://developer.r-project.org/db.

See Also

DBI base classes:

DBIObject-class DBIDriver-class DBIConnection-class DBIResult-class

MySQL classes:

MySQLObject-class MySQLDriver-class MySQLConnection-class MySQLResult-class

Examples

## Not run: 
drv <- dbDriver("MySQL")
con <- dbConnect(drv, dbname = "rsdbi.db")
## End(Not run)

[Package RMySQL version 0.6-0 Index]