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