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. http://www.sqlite.org/src/info/d1d84037b9 Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk6DZY4ACgkQmOOfHg372QRD6wCfVsqp+hqQjICe443M1HLoHoWQ VUkAnROp2ycwrlermzclYAWxYGklEPQz =k7wx -END PGP SIGNATURE- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 rog...@rogerbinns.com 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 release. great, thanks! -y ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 single quotes around the table name. If you do that then database names are not used. The table name is correctly quoted so it really makes no sense. sqlite attach '/tmp/foo' as foo; sqlite create table foo.bar(x); sqlite select * from foo.bar; sqlite select * from 'foo.bar'; SQLError: no such table: foo.bar Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk6Bo8wACgkQmOOfHg372QQ0+QCgqCr2wB19UqboO346U+pnzF7g tAcAoOHaEVZGnQequmfPZtXBsm7IEoXL =ZICf -END PGP SIGNATURE- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 which I can work around. I thought I would add a note to the wiki http://www.sqlite.org/cvstrac/wiki?p=ImportingFiles since that limitation is not documented anywhere that I've found. But I can't find a way to register and edit that page. At least now it will be in the mailing list archives. If someone with the know-how to register on that wiki wants me to make that edit, get in touch. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users