1.管理工具:sqlite expert professional
2 表操作 创建表、删除表、增加、删除、更新、查询
-- create table curse (cno char,cname char)
--insert into curse values('001','化学')
--select * from curse2
--update curse set cname='物理' where cno='001'
--delete from curse
--drop table curse
--alter table curse RENAME to curse2
--alter table curse2 add column updatetime char
--select * from curse limit 1 order by cno desc
--select * from curse limit 10,20 order by cno desc