dbWriteTable(...，append = T)在R中被覆盖 [英] dbWriteTable(..., append = T) is overwritng in R

问题描述

我正在使用RJDBC从R访问MySQL.之前，我曾经使用过R 2.15不能使用的RMySQL.关于SO的讨论很多，但仍然无法使用R 2.15中的RMySQL包，因此切换到RJDBC.

I am using RJDBC for accessing MySQL from R. Earlier I used to work with RMySQL which is not available for R 2.15. There were so many discussions around SO but still I couldn't able to use RMySQL package in R 2.15 so switched to RJDBC.

当我使用dbWriteTable(..., append = T)命令将记录追加到MySQL表中时，它只是被覆盖，请参见下面的代码.

When I'm using dbWriteTable(..., append = T) command for appending records into MySQL table it is simply overwriting, please see the code below.

Sys.setenv(MYSQL_HOME='C:/Program Files (x86)/MySQL/MySQL Server 5.1')

library(RJDBC)

MySQL连接

drv <- JDBC("com.mysql.jdbc.Driver","mysql-connector-java-5.0.5.jar", "`")
conn <- dbConnect(drv, "Retail", user="root", password="abc")
..................
..................
..................
dbWriteTable(conn, "Customer_Tbl", x, row.names=F,append = T)

Customer_Tbl每次都会覆盖，而不是附加.

Customer_Tbl is overwriting everytime instead of appending.

有人可以帮助解决这个问题吗?

Can somebody help in how to tackle this issue?

谢谢 Suresh

推荐答案

您需要使用overwrite = FALSE，并使用以下示例代码:

You need to use overwrite=FALSE, following sample code:

dbWriteTable(connection, name=tableName, value=rows , append=T, row.names=F, overwrite=F);

这篇关于dbWriteTable(...，append = T)在R中被覆盖的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！