[R] Delete query in sqldf?

[Gabor Grothendieck]

Yes but delete does not return anything so its not useful.  In the devel
version of sqldf you can pass multiple command so try this using the
builtin data frame BOD noting that the record with demand = 8.3 was
removed:

> library(sqldf)
Loading required package: RSQLite
Loading required package: DBI
Loading required package: gsubfn
Loading required package: proto
> # overwrite with devel version of the sqldf.R file
> source("http://sqldf.googlecode.com/svn/trunk/R/sqldf.R")
> sqldf(c("delete from BOD where demand = 8.3", "select * from BOD"))
  Time__1 demand
1       2   10.3
2       3   19.0
3       4   16.0
4       5   15.6
5       7   19.8


On 9/7/07, Paul Smith <phhs80 at gmail.com> wrote:
> Dear All,
>
> Is sqldf equipped with delete queries? I have tried delete queries but
> with no success.
>
> Thanks in advance,
>
> Paul
>
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>