I can work SQLite from by R stat package, but I am having hard time
mixing special sqlite command intermixed with SQL statements when I
send a text sequence to swqlite (even from the dos consol)
sqlite3 test.db .mode csv select * from selected limit 4
Makes sqlite choke because I do not know
On Tue, May 04, 2010 at 10:02:06AM -0700, Matt Young scratched on the wall:
sqlite3 test.db .mode csv select * from selected limit 4
Makes sqlite choke because I do not know what the inline terminator is
for a text invocation argument,
You can't put dot-commands on the command line.
To: sqlite-users@sqlite.org
Subject: [sqlite] Doing fine with SQLite
I can work SQLite from by R stat package, but I am having hard time
mixing special sqlite command intermixed with SQL statements when I
send a text sequence to swqlite (even from the dos consol)
sqlite3 test.db .mode csv select
You can't put dot-commands on the command line. Try:
I think you can with something like this (assuming your shell is bash):
echo $'.mode csv\nselect * from selected limit 4' | sqlite3 test.db
Pavel
On Tue, May 4, 2010 at 1:11 PM, Jay A. Kreibich j...@kreibi.ch wrote:
On Tue, May 04, 2010
You don't need to dump the data to a csv file and then read it into R
and there is no need to use the sqlite3 console at all as R's RSQLite
package can directly read and write SQLite databases. Also see the
sqldf package.
On Tue, May 4, 2010 at 1:02 PM, Matt Young youngsan...@gmail.com wrote:
I
All working. R had sufficient piping to files and allowed me to get it.
On 5/4/10, Gabor Grothendieck ggrothendi...@gmail.com wrote:
You don't need to dump the data to a csv file and then read it into R
and there is no need to use the sqlite3 console at all as R's RSQLite
package can directly