Rdocumentation
powered by
Learn R Programming
⚠️
There's a newer version (0.10.29) of this package.
Take me there.
RMySQL (version 0.10.2)
Database Interface and MySQL Driver for R
Description
Implements DBI-compliant Interface to MySQL and MariaDB Databases.
Copy Link
Link to current version
Version
Version
0.10.29
0.10.28
0.10.27
0.10.26
0.10.25
0.10.24
0.10.23
0.10.22
0.10.21
0.10.20
0.10.19
0.10.18
0.10.17
0.10.16
0.10.15
0.10.14
0.10.13
0.10.12
0.10.11
0.10.9
0.10.8
0.10.7
0.10.6
0.10.5
0.10.4
0.10.3
0.10.2
0.10.1
0.9-3
0.9-0
0.8-0
0.7-5
0.7-4
0.7-3
0.7-2
0.6-1
0.6-0
0.5-11
0.5-10
0.5-9
0.5-7
0.5-5
0.5-4
0.5-3
0.5-2
0.5-1
0.5-0
0.4-6
0.4-5
0.4-3
0.4-2
0.2-3
Install
install.packages('RMySQL')
Monthly Downloads
73,227
Version
0.10.2
License
GPL-2
Issues
47
Pull Requests
0
Stars
210
Forks
111
Repository
https://github.com/rstats-db/rmysql
Homepage
https://downloads.mariadb.org/client-native/
Maintainer
Jeroen Ooms
Last Published
February 24th, 2015
Functions in RMySQL (0.10.2)
Search all functions
dbApply
Apply R/S-Plus functions to remote groups of DBMS rows (experimental)
MySQLConnection-class
Class MySQLConnection.
MySQLResult-class
Class MySQLResult
dbDataType,MySQLDriver-method
Determine the SQL Data Type of an S object
dbColumnInfo,MySQLConnection-method
Experimental dbColumnInfo method for a connection
constants
Constants
MySQLDriver-class
Class MySQLDriver with constructor MySQL.
dbConnect,MySQLDriver-method
Connect/disconnect to a MySQL DBMS
dbReadTable,MySQLConnection,character-method
Convenience functions for importing/exporting DBMS tables
dbNextResult
Fetch next result set from an SQL script or stored procedure (experimental)
make.db.names,MySQLConnection,character-method
Make R/S-Plus identifiers into legal SQL identifiers
result-meta
Database interface meta-data.
mysqlClientLibraryVersions
MySQL Check for Compiled Versus Loaded Client Library Versions
mysqlBuildTableDefinition
Build the SQL CREATE TABLE definition as a string
dbFetch,MySQLResult,numeric-method
Execute a SQL statement on a database connection.
dbEscapeStrings
Escape SQL-special characters in strings.
dbQuoteIdentifier,MySQLConnection,character-method
Quote method for MySQL identifiers
dbGetInfo,MySQLDriver-method
Get information about a MySQL driver.
isIdCurrent
Check if a database object is valid.
mysqlHasDefault
Check if default database is available.
db-meta
Database interface meta-data
dbWriteTable,MySQLConnection,character,data.frame-method
Write a local data frame or file to the database.
dbUnloadDriver,MySQLDriver-method
Unload MySQL driver.
transactions
DBMS Transaction Management