sqlite限制查询数据数量limit data

iteye_13003

于 2013-10-02 23:38:17 发布

阅读量1.7k

点赞数

CC 4.0 BY-SA版权

分类专栏： sqlite 文章标签：乔乐共享 rowid limit data sqlite

本文链接：https://blog.youkuaiyun.com/iteye_13003/article/details/82542489

sqlite 专栏收录该内容

4 篇文章

订阅专栏

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