search for: iristab1

...exists) sqldf("attach myTestdbT as new") f1<-file("irisNoH.txt") attr(f1, "file.format") <- list(header=FALSE,sep="\t") # read into table called irisTab in the mytestdb sqlite database read.csv.sql("irisNoH.txt", sql = "create table main.irisTab1 as select * from file", dbname = "mytestdb") res1<-sqldf("select * from main.irisTab1 limit 10", dbname = "mytestdb") write.table(res1, "iris10.txt", sep = "\t", quote = FALSE, col.names=FALSE,row.names = FALSE) # For querying records of a...