df is dataframe in R and sql_table is table in sql
df
COlA COlB COlC
1 dfg jkl
2 fe jkl
3 rfew sdf
When I run below code , my sql table in sql has 3 rows (that is perfect)
sqlSave(conn, df, tablename = "sql_table", rownames = FALSE ,colnames = FALSE, append=TRUE)
But when I run the above code again, my sql table has only 3 rows since the old row are deleted. But I need to have 6 rows (3+3)
sqlSave(conn, df, tablename = "sql_table", rownames = FALSE ,colnames = FALSE, append=TRUE)