MySQLConnection-class {RMySQL}R Documentation

Class MySQLConnection

Description

MySQLConnection class.

Generators

The method dbConnect is the main generator.

Extends

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

Methods

coerce
signature(from = "MySQLConnection", to = "MySQLResult"): ...
dbCallProc
signature(conn = "MySQLConnection"): ...
dbCommit
signature(conn = "MySQLConnection"): ...
dbConnect
signature(drv = "MySQLConnection"): ...
dbDisconnect
signature(conn = "MySQLConnection"): ...
dbExistsTable
signature(conn = "MySQLConnection", name = "character"): ...
dbGetException
signature(conn = "MySQLConnection"): ...
dbGetInfo
signature(dbObj = "MySQLConnection"): ...
dbGetQuery
signature(conn = "MySQLConnection", statement = "character"): ...
dbListFields
signature(conn = "MySQLConnection", name = "character"): ...
dbListResults
signature(conn = "MySQLConnection"): ...
dbListTables
signature(conn = "MySQLConnection"): ...
dbReadTable
signature(conn = "MySQLConnection", name = "character"): ...
dbRemoveTable
signature(conn = "MySQLConnection", name = "character"): ...
dbRollback
signature(conn = "MySQLConnection"): ...
dbSendQuery
signature(conn = "MySQLConnection", statement = "character"): ...
dbWriteTable
signature(conn = "MySQLConnection", name = "character", value = "data.frame"): ...
summary
signature(object = "MySQLConnection"): ...

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]