RMySQL v0.10.16
0
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 | |
dbColumnInfo,MySQLConnection-method | Experimental dbColumnInfo method for a connection | |
db-meta | Database interface meta-data | |
dbApply | Apply R/S-Plus functions to remote groups of DBMS rows (experimental) | |
mysqlHasDefault | Check if default database is available. | |
dbGetInfo,MySQLDriver-method | Get information about a MySQL driver. | |
dbNextResult | Fetch next result set from an SQL script or stored procedure (experimental) | |
dbFetch,MySQLResult,numeric-method | Execute a SQL statement on a database connection. | |
dbReadTable,MySQLConnection,character-method | Convenience functions for importing/exporting DBMS tables | |
constants | Constants | |
MySQLResult-class | Class MySQLResult | |
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 | |
dbDataType,MySQLDriver-method | Determine the SQL Data Type of an S object | |
MySQLConnection-class | Class MySQLConnection. | |
MySQLDriver-class | Class MySQLDriver with constructor MySQL. | |
dbEscapeStrings | Escape SQL-special characters in strings. | |
mysqlBuildTableDefinition | Build the SQL CREATE TABLE definition as a string | |
mysqlClientLibraryVersions | MySQL Check for Compiled Versus Loaded Client Library Versions | |
dbUnloadDriver,MySQLDriver-method | Unload MySQL driver. | |
dbWriteTable,MySQLConnection,character,data.frame-method | Write a local data frame or file to the database. | |
dbQuoteIdentifier,MySQLConnection,character-method | Quote method for MySQL identifiers | |
dbConnect,MySQLDriver-method | Connect/disconnect to a MySQL DBMS | |
No Results! |
Last month downloads
Details
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' |
Packaged | 2019-01-02 10:47:38 UTC; jeroen |
Repository | CRAN |
Date/Publication | 2019-01-04 17:00:06 UTC |
suggests | curl , testthat |
depends | DBI (>= 0.4) , R (>= 2.8.0) |
imports | methods |
Contributors | RStudio, Saikat DebRoy, Hadley Wickham, David James, Jeffrey Horner |
Include our badge in your README
[](http://www.rdocumentation.org/packages/RMySQL)