Become an expert in R — Interactive courses, Cheat Sheets, certificates and more!

RMySQL

Database Interface and 'MySQL' Driver for R

Legacy 'DBI' interface to 'MySQL' / 'MariaDB' based on old code ported from S-PLUS. A modern 'MySQL' client based on 'Rcpp' is available from the 'RMariaDB' package.

Functions (24)

MySQLConnection-class

Class MySQLConnection.

MySQLDriver-class

Class MySQLDriver with constructor MySQL.

MySQLResult-class

Class MySQLResult

constants

Constants

db-meta

Database interface meta-data

dbApply

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

dbColumnInfo-MySQLConnection-method

Experimental dbColumnInfo method for a connection

dbConnect-MySQLDriver-method

Connect/disconnect to a MySQL DBMS

dbDataType-MySQLDriver-method

Determine the SQL Data Type of an S object

dbEscapeStrings

Escape SQL-special characters in strings.

dbGetInfo-MySQLDriver-method

Get information about a MySQL driver.

dbNextResult

Fetch next result set from an SQL script or stored procedure (experimental)

dbQuoteIdentifier-MySQLConnection-character-method

Quote method for MySQL identifiers

dbReadTable

Convenience functions for importing/exporting DBMS tables

dbUnloadDriver-MySQLDriver-method

Unload MySQL driver.

dbWriteTable

Write a local data frame or file to the database.

isIdCurrent

Check if a database object is valid.

make.db.names-MySQLConnection-character-method

Make R/S-Plus identifiers into legal SQL identifiers

mysqlBuildTableDefinition

Build the SQL CREATE TABLE definition as a string

mysqlClientLibraryVersions

MySQL Check for Compiled Versus Loaded Client Library Versions

mysqlHasDefault

Check if default database is available.

query

Execute a SQL statement on a database connection.

result-meta

Database interface meta-data.

transactions

DBMS Transaction Management

RMySQL

Database Interface and 'MySQL' Driver for R

v0.10.21

GPL-2

Authors

Jeroen Ooms [aut, cre] (<https://orcid.org/0000-0002-4035-0289>), David James [aut], Saikat DebRoy [aut], Hadley Wickham [aut], Jeffrey Horner [aut], RStudio [cph]

Initial release

RMySQL

Functions (24)

RMySQL

We don't support your browser anymore