Rdocumentation
powered by
Learn R Programming
RMySQL (version 0.11.2)
Database Interface and 'MySQL' Driver for R
Description
Legacy 'DBI' interface to 'MySQL' / 'MariaDB' based on old code ported from S-PLUS. A modern 'MySQL' client written in 'C++' is available from the 'RMariaDB' package.
Copy Link
Link to current version
Version
Version
0.11.2
0.11.1
0.11.0
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
44,295
Version
0.11.2
License
GPL-2
Maintainer
Jeroen Ooms
Last Published
March 2nd, 2026
Functions in RMySQL (0.11.2)
Search all functions
dbReadTable,MySQLConnection,character-method
Convenience functions for importing/exporting DBMS tables
dbQuoteIdentifier,MySQLConnection,character-method
Quote method for MySQL identifiers
MySQLConnection-class
Class MySQLConnection.
constants
Constants
dbDataType,MySQLDriver-method
Determine the SQL Data Type of an S object
dbEscapeStrings
Escape SQL-special characters in strings.
MySQLDriver-class
Class MySQLDriver with constructor MySQL.
db-meta
Database interface meta-data
dbApply
Apply R/S-Plus functions to remote groups of DBMS rows (experimental)
dbConnect,MySQLDriver-method
Connect/disconnect to a MySQL DBMS
isIdCurrent
Check if a database object is valid.
dbNextResult
Fetch next result set from an SQL script or stored procedure (experimental)
dbUnloadDriver,MySQLDriver-method
Unload MySQL driver.
dbWriteTable,MySQLConnection,character,data.frame-method
Write a local data frame or file to the database.
mysqlClientLibraryVersions
MySQL Check for Compiled Versus Loaded Client Library Versions
dbGetInfo,MySQLDriver-method
Get information about a MySQL driver.
make.db.names,MySQLConnection,character-method
Make R/S-Plus identifiers into legal SQL identifiers
dbColumnInfo,MySQLConnection-method
Experimental dbColumnInfo method for a connection
MySQLResult-class
Class MySQLResult
mysqlBuildTableDefinition
Build the SQL CREATE TABLE definition as a string
result-meta
Database interface meta-data.
mysqlHasDefault
Check if default database is available.
dbFetch,MySQLResult,numeric-method
Execute a SQL statement on a database connection.
transactions
DBMS Transaction Management