ead
> union
> select * from iristail')
> sqldf()
>
>> sqldf("select * from sqlite_master",dbname="mydb")$name
> [1] irishead iristail fulltable
> Levels: fulltable irishead iristail
>
> ? ...I'll try to go figure a few more things out in
df()
> sqldf("select * from sqlite_master",dbname="mydb")$name
[1] irishead iristail fulltable
Levels: fulltable irishead iristail
? ...I'll try to go figure a few more things out in the in the meantime (like
using sep="\t" ?) and using connections with s
Have just added an example 12 on the home page:
http://sqldf.googlecode.com
that shows an example. Note use of notation
main.mytable to refer to an existing table in the
main database (as opposed to a data frame in R).
On Thu, Feb 19, 2009 at 11:55 PM, Stephen Tucker wrote:
> Hi all,
>
> I am
Hi all,
I am attempting to learn SQL through sqldf...
One task I am particularly interested in is merging separate
(presumably large) files into a single table without loading these
files into R as an intermediate step (by loading them into SQLite and
merging them there).
Taking a step back, I'v
4 matches
Mail list logo
