echo .mode csv >input.sql echo select * from selected limit 4 >>input.sql sqlite3 test.db <input.sql Michael D. Black Senior Scientist Northrop Grumman Mission Systems
________________________________ From: sqlite-users-boun...@sqlite.org on behalf of Matt Young Sent: Tue 5/4/2010 12:02 PM 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 * from selected limit 4" Makes sqlite choke because I do not know what the inline terminator is for a text invocation argument, and can't find it in the docs. That is my last minor detail, and I have indices, joins, and unions going on the Bureau of Labor Statistic under R. Will make SQLite quite popular among the economists. Getting access to reams of data from economic we sites, directly into R dataframes via a set of common key words familiar to economists. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users