Learn R Programming

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

RMySQL (version 0.4-6)

R interface to the MySQL database

Description

Database interface and MySQL driver for R. This is a transitional version meant to fix some compatibility problems with the library(methods) and to port to Windows. The next major version will be entirely based on the DBI (see the package DBI 0.1-3) and Version 4 classes and methods, library(methods).

Copy Link

Version

Install

install.packages('RMySQL')

Monthly Downloads

70,047

Version

0.4-6

License

GPL

Homepage

www.omegahat.org

Maintainer

David James

Last Published

April 1st, 2025

Functions in RMySQL (0.4-6)

Describe an object through its meta-data

Get number of rows/columns of an SQL table

Create a connection to a RDBMS

Instantiate a database manager

Load/unload the client part of a database interface

Is a name an SQL keyword?

dbApply.MySQLResultSet

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

RDBMS Transaction Management

setDataMappings

Set data mappings between an RDBMS and R/S

Make R/S identifiers into legal SQL identifiers.

dbExecStatement

Execute an SQL statement on a given database connection

Convenience functions for Importing/Exporting DBMS tables into R/S.

Get a database manager object from a derived handle

Determine the SQL Data Type of an R/S object

Support MySQL methods

Quick SQL Execution

Call an SQL stored procedure

Check whether a database handle object is valid or not

Execute an SQL script on a given database connection

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

R/S database interface meta-data

Fetch records from a previously executed SELECT statement

Instantiate a MySQL client from the current R or S session

R compatibility with S version 4/Splus5+ support functions

Support objects for RS-DBI