Microsoft Windows [版本 6.1.7601]
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。

C:\Users\han>f:

F:\>cd F:\sqlite-tools-win32-x86-3120000

F:\sqlite-tools-win32-x86-3120000>sqlite3.exe mydb.db
sqlite version 3.12.0 2016-03-29 10:14:15
Enter ".help" for usage hints.
sqlite> .databases
seq  name             file

---  ---------------  ----------------------------------------------------

0    main             F:\sqlite-tools-win32-x86-3120000\mydb.db

sqlite> create table test(id integer default 0,username text);
sqlite> .tables
test
sqlite> insert into test(id,username)value(1,"test");
Error: near "value": Syntax error
sqlite> insert into test(id,username)values(1,"test");
sqlite> select * from test
   ...> ;
1|test
sqlite> .tables
test
sqlite> select * from test
   ...> ;
1|test
sqlite>

启动的时候 就要在 cmd 界面指明 db，没有则创建。