SQLite数据库经常使用的语句

create table t_student(sid INTEGER primary key autioincrement, sname varchar(20));


insert into t_student(sid,sname) values (1,'coolszy');


select sid,sname from t_student;


update t_student set sname='kuka' where sid=2;


delete from t_student where sid = 2;


select sid,sname from t_student limit (2,3);//2代表起始位置，3代表长度