综述

详细内容

create database test
create table test(id int,rd_time datetime default(strftime('%Y-%m-%d %H:%M:%f','now','localtime')))

insert into test (id) values(1)

select * from test
select max(rd_time) from test
select * from test where rd_time=(select max(rd_time) from test)
select * from test order by rd_time desc    // 降序
select * from test order by rd_time asc
select * from test order by rd_time desc limit 100 // 获取降序的 100 条记录

select * from (select * from test where id=1) where rd_time=(select max(rd_time) from (select * from test where id=1))

delete from test where id=1
delete from test

drop table test // 删除表

select * from sqlite_master //查询当前库中所有表单
pragma table_info(test) // 获取表信息