Rdocumentation
powered by
Learn R Programming
RMySQL (version 0.11.1)
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.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
70,047
Version
0.11.1
License
GPL-2
Maintainer
Jeroen Ooms
Last Published
April 1st, 2025
Functions in RMySQL (0.11.1)
Search all functions
result-meta
Database interface meta-data.
transactions
DBMS Transaction Management
dbWriteTable,MySQLConnection,character,data.frame-method
Write a local data frame or file to the database.
mysqlHasDefault
Check if default database is available.
dbFetch,MySQLResult,numeric-method
Execute a SQL statement on a database connection.
dbApply
Apply R/S-Plus functions to remote groups of DBMS rows (experimental)
MySQLConnection-class
Class MySQLConnection.
MySQLResult-class
Class MySQLResult
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
constants
Constants
dbEscapeStrings
Escape SQL-special characters in strings.
db-meta
Database interface meta-data
MySQLDriver-class
Class MySQLDriver with constructor MySQL.
make.db.names,MySQLConnection,character-method
Make R/S-Plus identifiers into legal SQL identifiers
isIdCurrent
Check if a database object is valid.
dbGetInfo,MySQLDriver-method
Get information about a MySQL driver.
mysqlClientLibraryVersions
MySQL Check for Compiled Versus Loaded Client Library Versions
mysqlBuildTableDefinition
Build the SQL CREATE TABLE definition as a string
dbUnloadDriver,MySQLDriver-method
Unload 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,MySQLConnection,character-method
Convenience functions for importing/exporting DBMS tables