I am trying to update rows from R to sql table. I am following below code for this. But the issue, when ever i run this, it delete the existing rows and then appends. Is there a way to only append the rows/
Example : In first instance, I am updating new rows (10) to sql table. At second instance, there are 90 rows, but since the below code deletes the existing rows, the final output is 90 rows in sql table. But actually, it should be 90+10 (100 rows). Is this possible to achieve?
sqlSave(conn, df, tablename = "sql_table", rownames = FALSE ,colnames = FALSE, append=TRUE)