dbDriver-methods {RMySQL} | R Documentation |
MySQL driver initialization and closing
MySQLDriver
as created by
dbDriver
.
fetch
with the n=
argument.FALSE
.
See the Database Interface definition document
DBI.pdf
in the base directory of this package
or
http://stat.bell-labs.com/RS-DBI.
MySQL
,
dbConnect
,
dbSendQuery
,
dbGetQuery
,
fetch
,
dbCommit
,
dbGetInfo
,
dbListTables
,
dbReadTable
.
## 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)