1、sqlite数据库执行full outer join失败
sqlite数据库执行full outer join时提示:RIGHT and FULL OUTER JOINs are not currently supported。
sqlite数据库不支持(+),不支持右外连接(right outer join)和全外连接(full outer join),但支持左外连接(left outer join)。我们可以利用这一点来得到全外连接的结果
2、曲线救国
以下aa、bb为数据表名
1.left outer join
select * From aa left outer join bb on aa.id=bb.id
2.right outer join
select * from bb left outer join aa on aa.id=bb.id
3.full outer join
select aa.*,bb.* from aa left outer join bb on aa.id=bb.id union select aa.*,bb.* from bb left outer join aa on aa.id=bb.id
3、sqlite3读写效率优化
4、sqlete3查询条件为比较数组
关键字,hex,x
sqlite - 与SQLite中的HEX()相反?
# x'fb71f32e000000000000' 会被转成一个数组 0xfb 0x71 ... 0x00 0x00
select * from t_RecordInfo where cardSid=x'fb71f32e000000000000'