Heya Folks, I can not find anything on executing insert statement through RMySQL, can someone please enlighten me? All i've found so far on getting data into a database is the write table functionality. Reading all data into memory appending additional information and writing that into a table is fine on my test environment, but won't be possible on the production environment because of the amount of data it will contain. Mazzel, Martijn.
RMySQL insert statements?
2 messages · Martijn Ras, Don MacQueen
Have you tried dbSendQuery() ? That is, construct an SQL insert statement and use it in dbSendQuery. Might have to follow it with dbCommit(). You could also use break your data up into smaller pieces and use dbWriteTable to write it a piece at a time, if really is too much to do all at once. -Don
At 12:56 PM +0200 5/5/09, Martijn Ras wrote:
Heya Folks, I can not find anything on executing insert statement through RMySQL, can someone please enlighten me? All i've found so far on getting data into a database is the write table functionality. Reading all data into memory appending additional information and writing that into a table is fine on my test environment, but won't be possible on the production environment because of the amount of data it will contain. Mazzel, Martijn.
______________________________________________ R-help at r-project.org mailing list https:// stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http:// www. R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
--------------------------------- Don MacQueen Lawrence Livermore National Laboratory Livermore, CA, USA 925-423-1062 macq at llnl.gov