[R-sig-DB] Bulk editing of mySQL tables

[Sean Davis]

On Wed, Mar 24, 2010 at 10:31 AM, Daniel Brewer <daniel.brewer using icr.ac.uk> wrote:
> It was suggested that this would be a better place to post this than the
> main R support list
>
> -----
>
> Hello,
>
> I have started to use RMySQL and I would like to use R to make batch
> changes to data.  What it the best way to do this?  Is it to download
> the table using dbGetQuery, manipulate the data in R and then
> dbWriteTable to delete the existing table and replace it with the local
> data.
>
> What I am concerned about this is that it might lose some mySQL table
> configuration options and it isn't a very effective way to do it.
>
> An example of the sort of thing I am doing is to try and update a column
> based on a CSV file stored locally.

Hi, Dan.  Perhaps you could be a bit more specific?  I think the usual
way to do this is with a SQL update.  Is there a reason not to do
things this way?

Sean