sqlite限制查询数据数量limit data
sqlite> select datetime(CreateTime, 'unixepoch', 'localtime'),Message,Des from Chat_af863d30e1c1e5eba27a0df37a75dba0 where ROWID < 2; +------------------------------------------------+----------+-----+ | datetime(CreateTime, 'unixepoch', 'localtime') | Message | Des | +------------------------------------------------+----------+-----+ | 2013-08-22 18:54:13 | 网络不好 | 1 | +------------------------------------------------+----------+-----+ 1 row in set
相关推荐
specialbrian 2020-07-31
loveandroid0 2020-06-18
DAV数据库 2020-06-17
URML 2020-06-13
Dlanguage 2020-06-12
Plant 2020-06-07
疯狂老司机 2020-06-07
chibangyuxun 2020-06-07
sdwylry 2020-06-04
airfling 2020-05-31
Plant 2020-05-31
zbcaicai 2020-05-26
chaochao 2020-05-19
Plant 2020-05-17
小火车 2020-05-14
beibeijia 2020-04-25
Rain 2020-04-16