Displaying 1 result from an estimated 1 matches for "myfullt".
Did you mean:
myfuel
2009 Feb 20
2
importing data to SQLite database with sqldf
...txt$") ) {
mydata <- read.delim(fi)
sql(sprintf("create table %s as select * from mydata",sub("\\.txt","",fi)))
}
rm(fi,mydata)
## (4) merge tables
tablenames <- as.character(sql("select * from sqlite_master")$name)
sql(paste("create table myfulltable as",
paste(sprintf("select * from %s",tablenames),
collapse=" union all ")))
## (5) delete separate tables since we have a merged one
for( nm in tablenames ) sql(sprintf("drop table %s",nm))
=== 3 ===
The following command
sqldf(&quo...