Re: [sqlite] .import difficulty

[A. Pagaltzis]

* cstrader232 <[EMAIL PROTECTED]> [2006-06-02 15:40]:
> strange error though because ";" can't be part of a tablename
> can it?

sqlite> create table [b;] (a,b,c);
sqlite> select * from sqlite_master;
type   name  tbl_name  rootpage  sql  
-        -
table  b;b;2 CREATE TABLE [b;] (a,b,c)

:-)

Regards,
-- 
Aristotle Pagaltzis // 

Re: [sqlite] .import difficulty

[cstrader232]

thanks all.  strange error though because ";" can't be part of a tablename can 
it?

Re: [sqlite] .import difficulty

[A. Pagaltzis]

* 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 // 

Re: [sqlite] .import difficulty

[Vishal Kashyap]

try

.import "test.txt" b ;

On 6/2/06, cstrader232 <[EMAIL PROTECTED]> wrote:


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"

tia







--
With Best Regards,
Vishal Kashyap.
http://www.vishal.net.in

[sqlite] .import difficulty

[cstrader232]

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"

tia