RMySQL: Database Interface and 'MySQL' Driver for R

Share:

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

Author
Jeroen Ooms [aut, cre], David James [aut], Saikat DebRoy [aut], Hadley Wickham [aut], Jeffrey Horner [aut], RStudio [cph]
Date of publication
2016-05-08 15:39:34
Maintainer
Jeroen Ooms <jeroen.ooms@stat.ucla.edu>
License
GPL-2
Version
0.10.9
URLs

View on CRAN

Man pages

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

Files in this package

RMySQL
RMySQL/tests
RMySQL/tests/testthat.R
RMySQL/tests/testthat
RMySQL/tests/testthat/dat-n.txt
RMySQL/tests/testthat/test-queries.R
RMySQL/tests/testthat/test-tables.R
RMySQL/tests/testthat/test-dbWriteTable.R
RMySQL/src
RMySQL/src/connection.c
RMySQL/src/S4R.h
RMySQL/src/fields.c
RMySQL/src/utils.c
RMySQL/src/driver.c
RMySQL/src/exception.c
RMySQL/src/db-apply.c
RMySQL/src/result.c
RMySQL/src/Makevars.in
RMySQL/src/RS-MySQL.h
RMySQL/src/getopt.h
RMySQL/src/Makevars.win
RMySQL/src/RMySQL-init.c
RMySQL/NAMESPACE
RMySQL/NEWS.md
RMySQL/R
RMySQL/R/mysql.R
RMySQL/R/connection.R
RMySQL/R/extension.R
RMySQL/R/data-type.R
RMySQL/R/driver.R
RMySQL/R/is-valid.R
RMySQL/R/result.R
RMySQL/R/escaping.R
RMySQL/R/transaction.R
RMySQL/R/default.R
RMySQL/R/table.R
RMySQL/README.md
RMySQL/MD5
RMySQL/DESCRIPTION
RMySQL/configure
RMySQL/man
RMySQL/man/constants.Rd
RMySQL/man/db-meta.Rd
RMySQL/man/isIdCurrent.Rd
RMySQL/man/MySQLConnection-class.Rd
RMySQL/man/dbGetInfo-MySQLDriver-method.Rd
RMySQL/man/dbQuoteIdentifier-MySQLConnection-character-method.Rd
RMySQL/man/MySQLDriver-class.Rd
RMySQL/man/mysqlClientLibraryVersions.Rd
RMySQL/man/dbColumnInfo-MySQLConnection-method.Rd
RMySQL/man/dbEscapeStrings.Rd
RMySQL/man/mysqlBuildTableDefinition.Rd
RMySQL/man/dbWriteTable.Rd
RMySQL/man/dbConnect-MySQLDriver-method.Rd
RMySQL/man/result-meta.Rd
RMySQL/man/transactions.Rd
RMySQL/man/dbNextResult.Rd
RMySQL/man/query.Rd
RMySQL/man/MySQLResult-class.Rd
RMySQL/man/mysqlHasDefault.Rd
RMySQL/man/dbApply.Rd
RMySQL/man/dbUnloadDriver-MySQLDriver-method.Rd
RMySQL/man/dbDataType-MySQLDriver-method.Rd
RMySQL/man/dbReadTable.Rd
RMySQL/man/make.db.names-MySQLConnection-character-method.Rd
RMySQL/configure.win
RMySQL/tools
RMySQL/tools/mysql-connector-c.rb
RMySQL/tools/winlibs.R