Skip to content

SQLDF syntax

3 messages · Gabor Grothendieck, new2R

new2R
# 
Hi, 

I am new to R and trying to migrate from SAS. I am trying to use sqldf to
create a new table from existed table and change some of the columns. I have
table called DataOld with columns commodity, rate and total and I am trying
to create new table called DataNew with columns commodity, ratenew and
totalNew.
I got error message " Error in sqliteExecStatement(con, statement,
bind.data) : 
  RS-DBI driver: (error in statement: near "*": syntax error)

Please help me in this regard.

Thank you



--
View this message in context: http://r.789695.n4.nabble.com/SQLDF-syntax-tp3458919p3458919.html
Sent from the R help mailing list archive at Nabble.com.
Gabor Grothendieck
#
On Mon, Apr 18, 2011 at 6:34 PM, new2R <bv_agrico at yahoo.co.in> wrote:
Its expression as name, not name as expression.  Try this:
demand Time demandPlusOne
1    8.3    1           9.3
2   10.3    2          11.3
3   19.0    3          20.0
4   16.0    4          17.0
5   15.6    5          16.6
6   19.8    7          20.8

For more, the sqldf home page at http://sqldf.googlecode.com has links
to sqlite site where you can find sql syntax diagrams. See the links
along the left side of the page there.