Re: [R] Bulk editing of mySQL tables

2010-03-24 Thread Albart
Hello Daniel, although I am not completely sure what you mean with 'batch changes to data'. Assuming that you want to modify the data in your tables, I would first try to do it in MySQL without exporting it to R and the importing it back. If it is to difficult to do in MySQL, for example a comple

[R] Bulk editing of mySQL tables

2010-03-24 Thread Daniel Brewer
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 c