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