Re: [sqlite] Sqlite shell's .import does not work with attached db's, add wiki note?

On Wed, Sep 28, 2011 at 2:21 PM, Roger Binns wrote: > On 09/26/2011 06:03 PM, yary wrote: >> I noticed that the sqlite shell won't ".import" into an attached database: > > You'll be pleased to know that the team have now fixed the bug. It will be > in the next SQLite

Re: [sqlite] Sqlite shell's .import does not work with attached db's, add wiki note?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/26/2011 06:03 PM, yary wrote: > I noticed that the sqlite shell won't ".import" into an attached database: You'll be pleased to know that the team have now fixed the bug. It will be in the next SQLite release.

Re: [sqlite] Sqlite shell's .import does not work with attached db's, add wiki note?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/26/2011 06:03 PM, yary wrote: > I noticed that the sqlite shell won't ".import" into an attached database: The cause of the error message is a test in the shell code. It prepares this: SELECT * from 'tablename' I have no idea why it puts

[sqlite] Sqlite shell's .import does not work with attached db's, add wiki note?

I noticed that the sqlite shell won't ".import" into an attached database: sqlite3.exe some.db sqlite> attach database 'foo.db' as foo_db; sqlite> create table foo_db.bar_tab (col1 varchar(40), col2 varchar(40)); sqlite> .import 'some_data.txt' foo_db.bar_tab Error: no such table: foo_db.bar_tab