Breaking News: Grepper is joining You.com. Read the official announcement!

update table in R

Friendly Flatworm answered on October 21, 2021 Popularity 3/10 Helpfulness 1/10

answer update table in R

update table in R

Comment

update <- function(i) {
drv <- dbDriver("PostgreSQL")
con <- dbConnect(drv, dbname="db_name", host="localhost", port="5432", user="chris", password="password")
txt <- paste("UPDATE data SET column_one=",data$column_one[i],",column_two=",data$column_two[i]," where id=",data$id[i])
dbGetQuery(con, txt)
dbDisconnect(con)
}


registerDoMC()

foreach(i = 1:length(data$column_one), .inorder=FALSE,.packages="RPostgreSQL")%dopar%{
update(i)
}

Popularity 3/10 Helpfulness 1/10 Language whatever

Source: stackoverflow.com

Tags: r whatever

Link to this answer
Share Copy Link