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