| dbConnect-methods {RMySQL} | R Documentation |
These methods are straight-forward implementations of the corresponding generic functions.
MySQLDriver, or
the character string "MySQL" or an MySQLConnection.
MySQLConnection object as produced by dbConnect.
"" is interpreted as "localhost".\$HOME/.my.cnf
to use for setting authentication parameters (see MySQL.)A connection between R/S-Plus and an MySQL server is established. The current implementation supports up to 100 simultaneous connections.
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,
dbReadTable.
## Not run:
# create an MySQL instance and create one connection.
drv <- dbDriver("MySQL")
# open the connection using user, passsword, etc., as
con <- dbConnect(drv, group = "rs-dbi")
# Run an SQL statement by creating first a resultSet object
rs <- dbSendQuery(con, statement = paste(
"SELECT w.laser_id, w.wavelength, p.cut_off",
"FROM WL w, PURGE P",
"WHERE w.laser_id = p.laser_id",
"SORT BY w.laser_id")
# we now fetch records from the resultSet into a data.frame
data <- fetch(rs, n = -1) # extract all rows
dim(data)
## End(Not run)