/usr/lib/R/site-library/RMySQL/README is in r-cran-rmysql 0.8-0-2.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 | $Id$
R/S-Plus Database Interface and the MySQL driver
For details, see the Adobe PDF file "DBI.pdf"" in this
library directory or help(MySQL).
This package implements an R/S4/Splus5+ to MySQL interface according
to the RS-Database Interface specification, see
http://www.omegahat.org/contrib/RS-DBI
The R/S MySQL implementation can handle multiple connections to
multiple MySQL servers.
Basic usage:
------------
# initialize S/Splus as a MySQL client
mgr <- dbDriver("MySQL")
# create a connection to a MySQL server
con <- dbConnect(mgr, user="user", pass="pass",
host="host", dbname="database")
# run a query, leave results on the server
rs <- dbSendQuery(con, "select * from A_TABLE")
# fetch up to, say, 50 records
a.table <- fetch(rs, n = 50)
# close resultSet rs and connection con
dbClearResult(rs); dbDisconnect(con)
Basic Methods:
--------------
summary(dbObj) # prints metadata for dbObj (e.g, mgr, con, rs)
dbGetInfo(dbObj) # returns a list of available metadata for dbObj
dbDisconnect(con) # closes dbObj (connection or resultSet)
dbClearReasults(res)
dbListTables(con)
dbListConnections(drv)
dbListResults(con)
|