2011 年 10月 27 日随笔档案 - meetcomet

2011年10月27日

摘要：使用的是SQLite1.建立SQLiteOpenHelper扩展类。public class DictionaryOpenHelper extends SQLiteOpenHelper { private static final int DATABASE_VERSION = 2; private static final String DICTIONARY_TABLE_NAME = "dictionary"; private static final String DICTIONARY_TABLE_CREATE = "CREATE TABLE " + 阅读全文

posted @ 2011-10-27 11:54 meetcomet 阅读(215) 评论(0) 推荐(0) 编辑

删除重复记录

摘要：删除表中多余的重复记录（多个字段），只留有rowid最小的记录delete from vitae awhere (a.peopleId,a.seq) in (select peopleId,seq from vitae group by peopleId,seq having count(*) > 1)and rowid not in (select min(rowid) from vitae group by peopleId,seq having count(*)>1)来源：http://www.cnblogs.com/jzaileen/archive/2008/08/29/1 阅读全文

posted @ 2011-10-27 09:18 meetcomet 阅读(128) 评论(0) 推荐(0) 编辑