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)