SQLite installation problems

I downloaded the binaries for windos for sqlite and ex开发者_JAVA百科tracted them. There were three files

1. a shell

2. dll

3. analyzer

when I try to run to create a database and a table from the sqlite shell i get....

  SQLite version 3.7.8 2011-09-19 14:49:19
  Enter ".help" for instructions
  Enter SQL statements terminated with a ";"
  sqlite> sqlite3 test.db
  ...> create table tbl1(one varchar(10), two smallint);
  Error: near "sqlite3": syntax error
  sqlite>

when I try to run to create a database and a table from the command line(Vista) shell I get....

Microsoft Windows [Version 6.0.6000]
Copyright (c) 2006 Microsoft Corporation.  All rights reserved.

C:\Users\codenamejupiterx>sqlite3 test.db
'sqlite3' is not recognized as an internal or external command,
operable program or batch file.

C:\Users\codenamejupiterx>

does anyone have any ideas?????

There is no "installation".

The error is that "sqlite3.exe" was not found in the search path as defined by the (Windows) PATH environment variable. Either add it to %PATH% (see How do I set or change the PATH system variable?) or use a complete file qualification that does not rely on %PATH%. A fully qualified invocation may look like:

C:\path\to\sqlite\sqlite3.exe test.db

Running sqlite3 by "double clicking" the executable in Windows Explorer is the same as above [as it uses an absolute path to run the sqlite3 executable] -- albeit without the ability to specify the database name or other options. (These can be specified in a "shortcut" to sqlite3, if desired.)

Happy coding.

You run the command sqlite3 test.db to start the sqlite shell. (your first example) From in there, you do not need that part of the command again, just issue the "create table " command.

I think you need this:

SQLite-1.0.66.0-setup.exe And sqliteadmin to open sqlite database

Regards