Sqlite3__Terminal

创建表
create table if not exists Student (id integer primary key autoincrement,name varchar[20] not null,address varchar[100],image blob);
查看自己的创建语句

插入数据
insert into Student(name,address) values("huoran","ruanjianyuan");
查找

select * from Student where id = 2;
select name from Student where id = 2;
更新
update Student set address = "nanjing" where name = "baoyun";

删除
delete from Student where id = 1;
删除表
drop table Student;
补充：
sqlite> SELECT * FROM COMPANY LIMIT 3 OFFSET 2;
从哪行开始至少几行