by Jeroen Ooms

Monthly downloads



License GPL-2
URL https://github.com/rstats-db/rmysql, https://downloads.mariadb.org/connector-c/
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 2016-05-07 18:20:46 UTC; jeroen
Repository CRAN
Date/Publication 2016-05-08 15:39:34

Database Interface and 'MySQL' Driver for R

Implements 'DBI' Interface to 'MySQL' and 'MariaDB' Databases.
Full Readme

Functions in RMySQL

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


Get your badge !