dbDriver-methods {RMySQL} | R Documentation

## MySQL implementation of the Database Interface (DBI) classes and drivers

### Description

MySQL driver initialization and closing

### Methods

drvName
  character name of the driver to instantiate.
drv
  an object that inherits from `MySQLDriver` as created by `dbDriver`.
max.con
  optional integer requesting the maximum number of simultanous connections (may be up to 100)
.
fetch.default.rec
  default number of records to retrieve per fetch. Default is 500. This may be overridden in calls to `fetch` with the `n=` argument.
force.reload
  optional logical used to force re-loading or recomputing the size of the connection table. Default is `FALSE`.
...
  currently unused.

### References

See the Database Interface definition document `DBI.pdf` in the base directory of this package or http://stat.bell-labs.com/RS-DBI.

### See Also

`MySQL`, `dbConnect`, `dbSendQuery`, `dbGetQuery`, `fetch`, `dbCommit`, `dbGetInfo`, `dbListTables`, `dbReadTable`.

### Examples

    ## Not run:
    # create an MySQL instance and set 10000 of rows per fetch.
    m <- dbDriver("MySQL", fetch.default.records=10000)

    con <- dbConnect(m, username="usr", password = "pwd",
               dbname = "iptraffic")
    rs <- dbSubmitQuery(con,
             "select * from HTTP_ACCESS where IP_ADDRESS = '127.0.0.1'")
    df <- fetch(rs, n = 50)
    df2 <- fetch(rs, n = -1)
    dbClearResult(rs)

    pcon <- dbConnect(p, group = "wireless")
    dbListTables(pcon)
    ## End(Not run)

[Package RMySQL version 0.6-0 Index]