SQLite 表操作

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