Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
tree: b347adef5a

Fetching latest commit…

Cannot retrieve the latest commit at this time

..
Failed to load latest commit information.
doc
FindMySQLhome.R
GPL
INSTALL
NEWS
README
README.windows
THANKS
TODO
WindowsPath.txt
newFunctionNames.txt

README

$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)
Something went wrong with that request. Please try again.