我有一个英语单词表 结果如下:
ID WORD OPTIME
1 groundwork 2009-11-19 23:06:16
2 illicit 2009-11-20 23:06:16
3 malnutrition 2009-11-19 23:06:16
4 unrest 2009-11-23 23:06:16
5 suicide 2009-11-25 23:06:16
6 reconciliation 2009-11-21 23:06:16
例如现在打印报表
select * from ENLISHWORD order by OPTIME DESC
数据排序应该如下:
5 suicide 2009-11-25 23:06:16
4 unrest 2009-11-23 23:06:16
6 reconciliation 2009-11-21 23:06:16
2 illicit 2009-11-20 23:06:16
1 groundwork 2009-11-19 23:06:16
3 malnutrition 2009-11-19 23:06:16
现在把打印过的单词存在了PrintLog表里
PrintDateTime KEYS
2010-06-17 17:36:29 '5','4','6','2','1','3'
我想浏览打印的数据:
select * from ENLISHWORD where id in('5','4','6','2','1','3')
结果出的数据的顺序是:
1 groundwork 2009-11-19 23:06:16
2 illicit 2009-11-20 23:06:16
3 malnutrition 2009-11-19 23:06:16
4 unrest 2009-11-23 23:06:16
5 suicide 2009-11-25 23:06:16
6 reconciliation 2009-11-21 23:06:16
而不是我想要的:
5 suicide 2009-11-25 23:06:16
4 unrest 2009-11-23 23:06:16
6 reconciliation 2009-11-21 23:06:16
2 illicit 2009-11-20 23:06:16
1 groundwork 2009-11-19 23:06:16
3 malnutrition 2009-11-19 23:06:16
文章来自Massage Shanghai:http://www.massageshanghaiescort.com
我遇到的一个SQLITE的奇怪问题
最新推荐文章于 2024-08-17 22:35:33 发布