Sqlite创建数据库，表

Microsoft Windows [版本 6.1.7601]版权所有 (c) 2009 Microsoft Corporation。保留所有权利。C:\Users\han>f:F:\>cd F:\sqlite-tools-win32-x86-3120000F:\sqlite-tools-win32-x86-3120000>sqlite3.exe mydb.dbSQLite version 3.12.0 2016-03-29 10:14:15Enter ".help" for usage hints.sqlite> .databasesseq  name             file---  ---------------  ----------------------------------------------------0    main             F:\sqlite-tools-win32-x86-3120000\mydb.dbsqlite> create table test(id integer default 0,username text);sqlite> .tablestestsqlite> insert into test(id,username)value(1,"test");Error: near "value": syntax errorsqlite> insert into test(id,username)values(1,"test");sqlite> select * from test   ...> ;1|testsqlite> .tablestestsqlite> select * from test   ...> ;1|testsqlite>

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