* cstrader232 <[EMAIL PROTECTED]> [2006-06-02 15:00]: > I'm having trouble importing. I'm using sqlite3 from dos. > > sqlite3 test.db; > create table b (a, b, c); > .import "test.txt" b; > > returns "no such table b"
No, it reports `Error: no such table: b;` – note the semicolon. A table called `b;` does indeed not exist. If you omit the semicolon or separate it with a space, the command will work. SQLite shell commands (which start with a dot) are single-line and need not be terminated. Regards, -- Aristotle Pagaltzis // <http://plasmasturm.org/>