我试图使用dbWriteTable方法将新数据附加到已存在的
MySQL表中.我以前用过它没有问题,但现在由于表已经存在而失败.尽管使用overwrite = FALSE,append = TRUE,
代码:
full_sum_table
dbWriteTable(conn=open_connection, name=full_sum_table, value=summary_data_final, overwrite=FALSE, append=TRUE, row.names=0)
Error in mysqlExecStatement(conn, statement, ...) :
RS-DBI driver: (could not run statement: Table 'summary' already exists)
[1] FALSE
Warning message:
In mysqlWriteTable(conn, name, value, ...) :
could not create table: aborting mysqlWriteTable
该代码的第一次调用工作正常,但后续调用失败.
任何想法将不胜感激.谢谢
环境:
R version 3.0.2
Packages: DBI (I was using RMySQL but it is not available for 3.0.2)
MySQL v5.6.14
OS: Windows Server 7