search for: iristab

...FALSE, col.names=FALSE,row.names = FALSE) # create an empty database (can skip this step if database already 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...