对于此查询，我想从其他数据库添加一列如何从sqlite中的其他数据库添加列 [英] for this query i want to add one column from other database how to add a column from other database in sqlite

问题描述

SELECT DISTINCT place_id，url，title，datetime（last_visit_date / 1000000，'unixepoch'）as last_visit_date FROM moz_annos a.place_id = b.id inner join moz_anno_attributes c on a.anno_attribute_id = c.id WHERE c.name LIKE'％downloads％';

SELECT DISTINCT place_id,url,title,datetime(last_visit_date/1000000,'unixepoch') as last_visit_date FROM moz_annos a inner join moz_places b on a.place_id=b.id inner join moz_anno_attributes c on a.anno_attribute_id =c.id WHERE c.name LIKE '%downloads%';

推荐答案

combine-two-sqlite-databases-in-bash [ ^ ]



如何合并多个数据库文件在sqlite中 [ ^ ]

这篇关于对于此查询，我想从其他数据库添加一列如何从sqlite中的其他数据库添加列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！