easyrodbcmysql: Simple Database Interface for MySQL
Version 0.7.8

Simple database interface for MySQL. easyrodbcmysql is build on top of RODBC. It provides functions for reading, writing, listing and subsetting tables in MySQL. easyrodbcmysql allow to retrieve, write and subset database's tables in a similar way as data.frame's, using single square brackets db[,,,]. easyrodbcmysql internalise many database operations (otherwise tedious) such as rows and columns subsetting (no SQL needed) and connection and disconnection to / from databases.

Browse man pages Browse package API and functions Browse package files

AuthorJulien MOEYS <Julien.Moeys@mark.slu.se>
Date of publication2016-06-09 09:01:13
MaintainerJulien MOEYS <Julien.Moeys@mark.slu.se>
LicenseAGPL-3
Version0.7.8
URL http://easydb.r-forge.r-project.org/
Package repositoryView on R-Forge
InstallationInstall the latest version of this package by entering the following in R:
install.packages("easyrodbcmysql", repos="http://R-Forge.R-project.org")

Man pages

easyrodbcmysql-package: Simple Database Interface for MySQL
edbColnames.RODBC_MySQL: Retrieve column names of a table in a MySQL database...
edbDataSource.RODBC_MySQL: Create an RODBC MySQL data source (from an 'edb' reference)....
edbDelete.RODBC_MySQL: Delete all or some rows in a table in a MySQL database...
edbDrop.RODBC_MySQL: Drop a table in a MySQL database (referenced by 'edb').
edbNames.RODBC_MySQL: Retrieve table names in a MySQL database (referenced by...
edbNRow.RODBC_MySQL: Retrieve the number of rows of a table in a database...
edbQuery.RODBC_MySQL: Send and retrieve a query in a SQLite database (referenced by...
edbRead.RODBC_MySQL: Read all or part of a table in a MySQL database (referenced...
edbWrite.RODBC_MySQL: Write data in a MySQL table in a database (referenced by...
z[_-.RODBC_MySQL: "[<-" method for MySQL databases. Write data in a MySQL table...
z[.RODBC_MySQL: "[" method for reading all or part of a table in a MySQL...

Functions

[.RODBC_MySQL Man page
[<-.RODBC_MySQL Man page
easyrodbcmysql Man page
easyrodbcmysql-package Man page
edbColnames.RODBC_MySQL Man page Source code
edbDataSource.RODBC_MySQL Man page Source code
edbDelete.RODBC_MySQL Man page Source code
edbDrop.RODBC_MySQL Man page Source code
edbNRow.RODBC_MySQL Man page Source code
edbNames.RODBC_MySQL Man page Source code
edbOperation.RODBC_MySQL Source code
edbQuery.RODBC_MySQL Man page Source code
edbRead.RODBC_MySQL Man page Source code
edbSearchPath Source code
edbSendGetQuery.RODBC_MySQL Source code
edbWrite.RODBC_MySQL Man page Source code
onAttach Source code

Files

DESCRIPTION
NAMESPACE
NEWS
R
R/easyrodbcmysql.R
R/onAttach.R
inst
inst/SVN_VERSION
inst/create_MySQL_db.sql
man
man/easyrodbcmysql-package.Rd
man/edbColnames.RODBC_MySQL.Rd
man/edbDataSource.RODBC_MySQL.Rd
man/edbDelete.RODBC_MySQL.Rd
man/edbDrop.RODBC_MySQL.Rd
man/edbNRow.RODBC_MySQL.Rd
man/edbNames.RODBC_MySQL.Rd
man/edbQuery.RODBC_MySQL.Rd
man/edbRead.RODBC_MySQL.Rd
man/edbWrite.RODBC_MySQL.Rd
man/z[.RODBC_MySQL.Rd
man/z[_-.RODBC_MySQL.Rd
tests
tests/edbColnames.RODBC_MySQL.R
tests/edbDelete.RODBC_MySQL.R
tests/edbDrop.RODBC_MySQL.R
tests/edbNames.RODBC_MySQL.R
tests/edbQuery.RODBC_MySQL.R
tests/edbRead.RODBC_MySQL.R
tests/edbWrite.RODBC_MySQL.R
easyrodbcmysql documentation built on May 21, 2017, 3:10 a.m.