RMySQL v0.10.20


Monthly downloads



Database Interface and 'MySQL' Driver for R

Legacy 'DBI' interface to 'MySQL' / 'MariaDB' based on old code ported from S-PLUS. A modern 'MySQL' client based on 'Rcpp' is available from the 'RMariaDB' package.

Functions in RMySQL

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

Last month downloads


License GPL-2
URL https://downloads.mariadb.org/connector-c/ (upstream)
BugReports https://github.com/r-dbi/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'
RoxygenNote 7.0.2
Packaged 2020-03-14 00:57:22 UTC; jeroen
Repository CRAN
Date/Publication 2020-03-14 05:40:08 UTC

Include our badge in your README