RMySQL v0.10.12


Monthly downloads



by Jeroen Ooms

Database Interface and 'MySQL' Driver for R

A 'DBI' interface to 'MySQL' / 'MariaDB'. The 'RMySQL' package contains an old implementation based on legacy code from S-PLUS which being phased out. A modern 'MySQL' client based on 'Rcpp' is available from the 'RMariaDB' package on 'Github': <https://github.com/rstats-db/RMariaDB>.

Functions in RMySQL

Name Description
dbDataType,MySQLDriver-method Determine the SQL Data Type of an S object
dbEscapeStrings Escape SQL-special characters in strings.
dbGetInfo,MySQLDriver-method Get information about a MySQL driver.
dbNextResult Fetch next result set from an SQL script or stored procedure (experimental)
dbColumnInfo,MySQLConnection-method Experimental dbColumnInfo method for a connection
dbConnect,MySQLDriver-method Connect/disconnect to a MySQL DBMS
isIdCurrent Check if a database object is valid.
make.db.names,MySQLConnection,character-method Make R/S-Plus identifiers into legal SQL identifiers
result-meta Database interface meta-data.
transactions DBMS Transaction Management
db-meta Database interface meta-data
dbApply Apply R/S-Plus functions to remote groups of DBMS rows (experimental)
dbQuoteIdentifier,MySQLConnection,character-method Quote method for MySQL identifiers
MySQLResult-class Class MySQLResult
constants Constants
dbUnloadDriver,MySQLDriver-method Unload MySQL driver.
dbWriteTable,MySQLConnection,character,data.frame-method Write a local data frame or file to the database.
MySQLConnection-class Class MySQLConnection.
MySQLDriver-class Class MySQLDriver with constructor MySQL.
mysqlBuildTableDefinition Build the SQL CREATE TABLE definition as a string
mysqlClientLibraryVersions MySQL Check for Compiled Versus Loaded Client Library Versions
dbReadTable,MySQLConnection,character-method Convenience functions for importing/exporting DBMS tables
mysqlHasDefault Check if default database is available.
dbFetch,MySQLResult,numeric-method Execute a SQL statement on a database connection.
No Results!

Last month downloads


License GPL-2
URL https://github.com/rstats-db/RMySQL#readme (devel) https://downloads.mariadb.org/connector-c/ (upstream)
BugReports https://github.com/rstats-db/rmysql/issues
SystemRequirements libmariadb-client-dev | libmariadb-client-lgpl-dev | libmysqlclient-dev (deb), mariadb-devel (rpm), mariadb | mysql-connector-c (brew), mysql56_dev (csw)
NeedsCompilation yes
Collate 'mysql.R' 'driver.R' 'connection.R' 'data-type.R' 'default.R' 'escaping.R' 'result.R' 'extension.R' 'is-valid.R' 'table.R' 'transaction.R'
Packaged 2017-07-05 16:24:26 UTC; jeroen
Repository CRAN
Date/Publication 2017-07-06 10:50:03 UTC

Include our badge in your README