Re: [R] error message from sqldf

On Sat, Mar 10, 2018 at 09:30:42PM +, Ding, Yuan Chun wrote: > 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 a

[R] error message from sqldf

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, Ding chr10 <- sqldf("select * from manifest where CHR==10") UCN3cpg <- sqldf("select * from chr10 where MA