Rdocumentation
powered by
Learn R Programming
⚠️
There's a newer version (0.10.29) of this package.
Take me there.
RMySQL (version 0.9-3)
R interface to the MySQL database
Description
Database interface and MySQL driver for R. This version complies with the database interface definition as implemented in the package DBI 0.2-2.
Copy Link
Link to current version
Version
Version
0.10.29
0.10.28
0.10.27
0.10.26
0.10.25
0.10.24
0.10.23
0.10.22
0.10.21
0.10.20
0.10.19
0.10.18
0.10.17
0.10.16
0.10.15
0.10.14
0.10.13
0.10.12
0.10.11
0.10.9
0.10.8
0.10.7
0.10.6
0.10.5
0.10.4
0.10.3
0.10.2
0.10.1
0.9-3
0.9-0
0.8-0
0.7-5
0.7-4
0.7-3
0.7-2
0.6-1
0.6-0
0.5-11
0.5-10
0.5-9
0.5-7
0.5-5
0.5-4
0.5-3
0.5-2
0.5-1
0.5-0
0.4-6
0.4-5
0.4-3
0.4-2
0.2-3
Install
install.packages('RMySQL')
Monthly Downloads
73,227
Version
0.9-3
License
GPL-2
Issues
47
Pull Requests
0
Stars
210
Forks
111
Repository
https://github.com/jeffreyhorner/RMySQL
Homepage
http://biostat.mc.vanderbilt.edu/RMySQL
Maintainer
Jeffrey Horner
Last Published
January 17th, 2012
Functions in RMySQL (0.9-3)
Search all functions
MySQLResult-class
Class MySQLResult
safe.write
Write a data.frame avoiding exceeding memory limits
MySQL
Instantiate a MySQL client from the current R session
mysqlClientLibraryVersions
MySQL Check for Compiled Versus Loaded Client Library Versions
dbSendQuery-methods
Execute a statement on a given database connection
isIdCurrent
Check whether a database handle object is valid or not
S4R
R compatibility with S version 4/Splus5+ support functions
mysqlSupport
Support Functions
dbApply-methods
Apply R/S-Plus functions to remote groups of DBMS rows (experimental)
dbBuildTableDefinition
Build the SQL CREATE TABLE definition as a string
dbEscapeStrings
Escape SQL-special characters in strings
dbDriver-methods
MySQL implementation of the Database Interface (DBI) classes and drivers
MySQLObject-class
Class MySQLObject
dbCommit-methods
DBMS Transaction Management
dbObjectId-class
Class dbObjectId
mysqlDBApply
Apply R/S-Plus functions to remote groups of DBMS rows (experimental)
dbNextResult
Fetch next result set from an SQL script or stored procedure (experimental)
dbApply
Apply R functions to remote groups of DBMS rows (experimental)
dbGetInfo-methods
Database interface meta-data
fetch-methods
Fetch records from a previously executed query
MySQLDriver-class
Class MySQLDriver
dbConnect-methods
Create a connection object to an MySQL DBMS
summary-methods
Summarize an MySQL object
MySQLConnection-class
Class MySQLConnection
dbNextResult-methods
Fetch Next Result Set from Multiple Statements or Stored Procedures
dbCallProc-methods
Call an SQL stored procedure
dbEscapeStrings-methods
Escape a Character Vector According to SQL rules
RMySQL-package
R interface to the MySQL database
dbListTables-methods
List items from an MySQL DBMS and from objects
dbReadTable-methods
Convenience functions for Importing/Exporting DBMS tables
dbDataType-methods
Determine the SQL Data Type of an S object
make.db.names-methods
Make R/S-Plus identifiers into legal SQL identifiers
dbSetDataMappings-methods
Set data mappings between MySQL and R/S-Plus