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