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