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]