建库:C:\>sqlite3 test.db
建表:create table user(id integer,name text,sex text);
新建数据:insert into user values(1,'zoe','girl');
查询数据:select * from user;
更新数据:update user set name='fei',sex='boy' where id=1;
删除数据:delete from user where name='fei';
想了解更详细的,可以看
https://www.runoob.com/sqlite/sqlite-tutorial.html