SQLite installation problems
10,897
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.
Related videos on Youtube
Author by
codenamejupiterx
Updated on June 04, 2022Comments
-
codenamejupiterx almost 2 years
I downloaded the binaries for windos for sqlite and extracted them. There were three files
a shell
dll
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?????