Re^2: SQLite function .import not working

You monks are indeed wise. Thank you very much. I have it now.
.import is not something the database understands. Therefore, I just tried

system "sqlite3 databasename \".import filename tablename\"";

and it worked! I think the same would work for all the other sqlite3 functions that begins with a dot (".").

Comment on Re^2: SQLite function .import not working

Replies are listed 'Best First'.
Re^3: SQLite function .import not working by toolic (Bishop) on Oct 16, 2007 at 20:57 UTC
By the way, you can avoid escaping double-quotes by using the qq operator, as follows: `system qq{sqlite3 databasename ".import filename tablename"};` [download]	[reply] [d/l]
Re^3: SQLite function .import not working by Anonymous Monk on Jun 01, 2010 at 21:37 UTC
But... I need to do `sqlite3 dbname .separator \t .import filename tablename` [download] How can I do that? (put 2 sqlite3 commands on the command line)?	[reply] [d/l]
Re^4: SQLite function .import not working by Anonymous Monk on Jun 02, 2010 at 00:43 UTC
Maybe `system 'sqlite3', 'dbname', ".separator \t\n.import filename tablename +";` [download] But really, you need to `perldoc -f system` and `man sqlite3`	[reply] [d/l]