Dear Simon, I am trying other ways. To learn about command line shell I created the following example: * SQLite version 3.7.10 2012-01-16 13:28:40 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> sqlite3 alphaDB ...> create table contact(name TEXT, city TEXT); Error: near "sqlite3": syntax error sqlite>*
What is wrong? It's like the documentation teachs. 2012/3/15 Simon Slavin <[email protected]> > > On 15 Mar 2012, at 7:11pm, Waltênio de Bessa Mendes < > [email protected]> wrote: > > >> *SQLite version 3.7.10 2012-01-16 13:28:40 > >> Enter ".help" for instructions > >> Enter SQL statements terminated with a ";" > >> sqlite> $ sqlite3 Biblia > >> ...> ; > >> Error: unrecognized token: "$" > >> sqlite> .tables > >> sqlite> select * from LivroDaBilia; > >> Error: no such table: LivroDaBilia > > The 'sqlite3 <filename>' command goes to your shell. It's not typed into > the shell tool, it's used to start the shell tool and tell it what file to > use. > > I agree with Michael. You're telling your application to open the wrong > file. It's creating a new blank database with no tables in. Which > explains your error message. > > Simon. > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
