且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

sqlite:只读数据库中的临时表/视图?

更新时间:2023-01-22 08:09:05

您可以创建一个引用主数据库中数据的临时视图.

You can create a temporary view that references data in the main db.

CREATE VIEW temp.userview AS select userid, firstname, lastname from main.usertbl;

然后像这样访问视图...

Then access the view like such...

SELECT * from temp.userview;