easyrodbcmysql: Simple Database Interface for MySQL

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.

Author
Julien MOEYS <Julien.Moeys@mark.slu.se>
Date of publication
2016-06-09 09:01:13
Maintainer
Julien MOEYS <Julien.Moeys@mark.slu.se>
License
AGPL-3
Version
0.7.8
URLs

View on R-Forge

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...

Files in this package

easyrodbcmysql/DESCRIPTION
easyrodbcmysql/NAMESPACE
easyrodbcmysql/NEWS
easyrodbcmysql/R
easyrodbcmysql/R/easyrodbcmysql.R
easyrodbcmysql/R/onAttach.R
easyrodbcmysql/inst
easyrodbcmysql/inst/SVN_VERSION
easyrodbcmysql/inst/create_MySQL_db.sql
easyrodbcmysql/man
easyrodbcmysql/man/easyrodbcmysql-package.Rd
easyrodbcmysql/man/edbColnames.RODBC_MySQL.Rd
easyrodbcmysql/man/edbDataSource.RODBC_MySQL.Rd
easyrodbcmysql/man/edbDelete.RODBC_MySQL.Rd
easyrodbcmysql/man/edbDrop.RODBC_MySQL.Rd
easyrodbcmysql/man/edbNRow.RODBC_MySQL.Rd
easyrodbcmysql/man/edbNames.RODBC_MySQL.Rd
easyrodbcmysql/man/edbQuery.RODBC_MySQL.Rd
easyrodbcmysql/man/edbRead.RODBC_MySQL.Rd
easyrodbcmysql/man/edbWrite.RODBC_MySQL.Rd
easyrodbcmysql/man/z[.RODBC_MySQL.Rd
easyrodbcmysql/man/z[_-.RODBC_MySQL.Rd
easyrodbcmysql/tests
easyrodbcmysql/tests/edbColnames.RODBC_MySQL.R
easyrodbcmysql/tests/edbDelete.RODBC_MySQL.R
easyrodbcmysql/tests/edbDrop.RODBC_MySQL.R
easyrodbcmysql/tests/edbNames.RODBC_MySQL.R
easyrodbcmysql/tests/edbQuery.RODBC_MySQL.R
easyrodbcmysql/tests/edbRead.RODBC_MySQL.R
easyrodbcmysql/tests/edbWrite.RODBC_MySQL.R