AkhilNairAmey/dbUpdateTable: Create and update keyed MySQL tables from R

The main purpose of this package is to provide a single function to update table in a MySQL database by key. To achieve this, there first must be a method to create a keyed MySQL table available. This set up naturally lends itself to data.table where tables can be keyed natively The update is achieved via a DELETE + INSERT. The INSERT uses the standard RMySQL function. The delete could be improved as this is just string parsing.

Getting started

Package details

LicenseMIT + file LICENSE
Package repositoryView on GitHub
Installation Install the latest version of this package by entering the following in R:
AkhilNairAmey/dbUpdateTable documentation built on May 5, 2019, 1:35 p.m.