⚠️There's a newer version (0.11.1) of this package.Take me there.

RMySQL (version 0.10.17)

Database Interface and 'MySQL' Driver for R

Description

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.

Copy Link

Version

Install

install.packages('RMySQL')

Monthly Downloads

70,047

Version

0.10.17

License

GPL-2

Maintainer

Jeroen Ooms

Last Published

March 4th, 2019

Functions in RMySQL (0.10.17)

MySQLResult-class

Class MySQLResult

dbDataType,MySQLDriver-method

Determine the SQL Data Type of an S object

db-meta

Database interface meta-data

mysqlClientLibraryVersions

MySQL Check for Compiled Versus Loaded Client Library Versions

dbApply

Apply R/S-Plus functions to remote groups of DBMS rows (experimental)

dbNextResult

Fetch next result set from an SQL script or stored procedure (experimental)

dbGetInfo,MySQLDriver-method

Get information about a MySQL driver.

constants

Constants

mysqlBuildTableDefinition

Build the SQL CREATE TABLE definition as a string

dbEscapeStrings

Escape SQL-special characters in strings.

make.db.names,MySQLConnection,character-method

Make R/S-Plus identifiers into legal SQL identifiers

MySQLDriver-class

Class MySQLDriver with constructor MySQL.

dbQuoteIdentifier,MySQLConnection,character-method

Quote method for MySQL identifiers

mysqlHasDefault

Check if default database is available.

dbFetch,MySQLResult,numeric-method

Execute a SQL statement on a database connection.

dbReadTable,MySQLConnection,character-method

Convenience functions for importing/exporting DBMS tables

result-meta

Database interface meta-data.

transactions

DBMS Transaction Management

isIdCurrent

Check if a database object is valid.

dbColumnInfo,MySQLConnection-method

Experimental dbColumnInfo method for a connection

dbConnect,MySQLDriver-method

Connect/disconnect to a MySQL DBMS

MySQLConnection-class

Class MySQLConnection.

dbUnloadDriver,MySQLDriver-method

Unload MySQL driver.

dbWriteTable,MySQLConnection,character,data.frame-method

Write a local data frame or file to the database.