1. 统计track表中所有记录总数
select count(*) from track;
2. 更新数据库中localtime字段datetime为long型时间戳
update track set localtime=REPLACE(localtime, localtime, strftime('%s',localtime));
3. 查询每个imei号对应的最后一条位置信息
SELECT longitude, latitude, state, imei FROM track WHERE ROWID in (SELECT MAX(ROWID) from track WHERE utctime>0 GROUP BY imei) ORDER BY utctime DESC;