On 16 Mar 2012, at 2:08pm, Waltênio de Bessa Mendes <walteniobe...@gmail.com> 
wrote:

> 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.

You put the 'sqlite3 alphaDB' command to your operating system.  You don't type 
it into the sqlite3 shell program, instead you use that line to start the 
sqlite3 program.  You don't type it into the program when it is already started.

So you should have something like

C:\> sqlite3 alphaDB
SQLite version 3.7.10 2012-01-16 13:28:40
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table contact(name TEXT, city TEXT);


Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to