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]