Learn R Programming

⚠️There's a newer version (0.11.1) of this package.Take me there.

RMySQL (version 0.5-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.1-4.

Copy Link

Version

Install

install.packages('RMySQL')

Monthly Downloads

61,573

Version

0.5-3

License

GPL

Maintainer

David James

Last Published

April 1st, 2025

Functions in RMySQL (0.5-3)

MySQLObject-class

Class MySQLObject
mysqlDBApply

Apply R/S-Plus functions to remote groups of DBMS rows (experimental)
dbApply

Apply R/S-Plus functions to remote groups of DBMS rows (experimental)
MySQLDriver-class

Class MySQLDriver
dbSendQuery-methods

Execute a statement on a given database connection
dbDriver-methods

MySQL implementation of the Database Interface (DBI) classes and drivers
dbConnect-methods

Create a connection object to an MySQL DBMS
make.db.names-methods

Make R/S-Plus identifiers into legal SQL identifiers
dbReadTable-methods

Convenience functions for Importing/Exporting DBMS tables
safe.write

Write a data.frame avoiding exceeding memory limits
dbSetDataMappings-methods

Set data mappings between MySQL and R/S-Plus
MySQL

Instantiate a MySQL client from the current R or S-Plus session
dbDataType-methods

Determine the SQL Data Type of an S object
S4R

R compatibility with S version 4/Splus5+ support functions
MySQLConnection-class

Class MySQLConnection
summary-methods

Summarize an MySQL object
dbObjectId-class

Class dbObjectId
mysqlSupport

Support Functions
dbCommit-methods

DBMS Transaction Management
isIdCurrent

Check whether a database handle object is valid or not
fetch-methods

Fetch records from a previously executed query
dbGetInfo-methods

Database interface meta-data
dbApply-methods

Apply R/S-Plus functions to remote groups of DBMS rows (experimental)
dbListTables-methods

List items from an MySQL DBMS and from objects
dbCallProc-methods

Call an SQL stored procedure
MySQLResult-class

Class MySQLResult