d*******1 发帖数: 854 | 2 在R里面运行sqlite syntax, 下面第一个命令运行无误, 但是第二个出了问题
all<- sqldf("select a.*, b.cutnum from all_resx a, cut b where a.cut=b.cut")
allx<- sqldf("select a.*, b.cut cutx from all a, cut b where b.cutnum-a.
cutnum=1")
出错信息如下:
Error in sqliteExecStatement(con, statement, bind.data) :
RS-DBI driver: (error in statement: near "all": syntax
error)
Calls: sqldf ... dbGetQuery -> sqliteQuickSQL ->
sqliteExecStatement -> .Call
Execution halted
那位大侠给点... 阅读全帖 |
|