Using the package /RMySQL/ I have established a connection ('con1') to a
MySQL-Database called 'mc'.
This database contains a table called 'mc_2000' which has 200000 observations
on several
variables. One of these variables is called 'B5' (type 'double').
When I generate a numeric vector in R called 'B6' that has the same length as
'B5': How
can I replace the values of 'B5' with the values of 'B6'? I tried
dbGetQuery(con1,
"UPDATE mc_2000 SET B5 = B6", B6)
but this doesn't work. The same applies to:
dbGetQuery(con1,
"REPLACE mc_2000(B5) VALUES(B6)", B6)
Any help would be appreciated very much.
Marcus Wurzer
______________________________________________
R-help@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.
