参考:

SQLite数据库版本升级
https://blog.csdn.net/feibendexiaoma/article/details/79526187

sqlite 升级
https://blog.csdn.net/coding_or_coded/article/details/7778865?spm=1001.2101.3001.6650.1&utm_medium=distribute.pc_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7Edefault-1.pc_relevant_paycolumn_v2&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7Edefault-1.pc_relevant_paycolumn_v2&utm_relevant_index=2

Android数据库Sqlite的基本用法及升级策略
https://blog.csdn.net/u013700502/article/details/78764917?utm_medium=distribute.pc_relevant.none-task-blog-2~default~baidujs_baidulandingword~default-1.pc_relevant_paycolumn_v2&spm=1001.2101.3001.4242.2&utm_relevant_index=4

update和upgrade的主要区别
https://blog.csdn.net/liuzehn/article/details/83651587

参考:

sql 语句中as的用法和作用
https://www.cnblogs.com/alex0702/p/10766821.html

sqlite之query、rawQuery区别；moveToNext，moveToFirst区别
https://blog.csdn.net/sinat_31057219/article/details/79410588

Android 使用SQLite数据库使用Cursor（游标）来进行操作
https://blog.csdn.net/guodongsun0/article/details/45417707

sqlite使用总结
https://www.jianshu.com/p/39f9fc519077?nomobile=yes

参考:

sql语句查询多对多数据各个状态的数量
https://blog.csdn.net/qq_40393093/article/details/84190999

SQL查询记录总数
https://blog.csdn.net/iiithsoul/article/details/9977709?spm=1001.2101.3001.6650.1&utm_medium=distribute.pc_relevant.none-task-blog-2%7Edefault%7ELandingCtr%7Edefault-1.queryctr&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2%7Edefault%7ELandingCtr%7Edefault-1.queryctr&utm_relevant_index=2

SQL查记录总数-总数统计的方法
https://blog.csdn.net/q2941467430/article/details/119112313?spm=1001.2101.3001.6650.1&utm_medium=distribute.pc_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7Edefault-1.pc_relevant_paycolumn_v2&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7Edefault-1.pc_relevant_paycolumn_v2&utm_relevant_index=2

如何统计SQL语句查询出来的条数？
https://bbs.csdn.net/topics/350165319

sql查询语句,查数据库中一共多少条记录
https://ask.zol.com.cn/x/10763978.html

sql语句统计查询结果数量怎么写？
https://zhidao.baidu.com/question/1900371557735372700.html

SQL语句——查询记录的数量
https://blog.csdn.net/duling509/article/details/3400718

参考:

SQLite重置主键字段
https://www.imooc.com/wenda/detail/585683

Sqlite 清空表中所有数据 并重置自增长数据
https://blog.csdn.net/hn307165411/article/details/7084974