Rdocumentation
powered by
Learn R Programming
⚠️
There's a newer version (0.11.1) of this package.
Take me there.
RMySQL (version 0.5-9)
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-8.
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.5-9
License
GPL
Maintainer
David James
Last Published
April 1st, 2025
Functions in RMySQL (0.5-9)
Search all functions
MySQLConnection-class
Class MySQLConnection
dbCallProc-methods
Call an SQL stored procedure
dbReadTable-methods
Convenience functions for Importing/Exporting DBMS tables
MySQLDriver-class
Class MySQLDriver
dbObjectId-class
Class dbObjectId
MySQLResult-class
Class MySQLResult
dbApply-methods
Apply R/S-Plus functions to remote groups of DBMS rows (experimental)
fetch-methods
Fetch records from a previously executed query
dbApply
Apply R/S-Plus functions to remote groups of DBMS rows (experimental)
dbCommit-methods
DBMS Transaction Management
dbSendQuery-methods
Execute a statement on a given database connection
S4R
R compatibility with S version 4/Splus5+ support functions
dbConnect-methods
Create a connection object to an MySQL DBMS
dbSetDataMappings-methods
Set data mappings between MySQL and R/S-Plus
MySQLObject-class
Class MySQLObject
safe.write
Write a data.frame avoiding exceeding memory limits
dbDataType-methods
Determine the SQL Data Type of an S object
dbListTables-methods
List items from an MySQL DBMS and from objects
dbDriver-methods
MySQL implementation of the Database Interface (DBI) classes and drivers
RMySQL-package
R interface to the MySQL database
isIdCurrent
Check whether a database handle object is valid or not
summary-methods
Summarize an MySQL object
mysqlSupport
Support Functions
make.db.names-methods
Make R/S-Plus identifiers into legal SQL identifiers
MySQL
Instantiate a MySQL client from the current R or S-Plus session
dbGetInfo-methods
Database interface meta-data
mysqlDBApply
Apply R/S-Plus functions to remote groups of DBMS rows (experimental)
dbBuildTableDefinition
Build the SQL CREATE TABLE definition as a string