[R] error message from sqldf

Ding, Yuan Chun ycding at coh.org
Sat Mar 10 22:30:42 CET 2018

Dear R users,

I got the following error message from running sqldf code in R.   do you know how to fix it?  I read the sqldf package instruction and did not find a solution.

Thank you,


chr10 <- sqldf("select * from manifest where CHR==10")

UCN3cpg <-  sqldf("select * from chr10 where MAPINFO between 5405573 and 5407594),
overwrite = TRUE")
Error: Table chr10 exists in database, and both overwrite and append are FALSE


This message (and any attachments) are intended solely f...{{dropped:22}}

More information about the R-help mailing list