創(chuàng)建表
create table if not exists Student (id integer primary key autoincrement,name varchar[20] not null,address varchar[100],image blob);
查看自己的創(chuàng)建語句
插入數(shù)據(jù)
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;
補(bǔ)充：
sqlite> SELECT * FROM COMPANY LIMIT 3 OFFSET 2;
從哪行開始至少幾行
