How to loop to attach many sqlite database and loop different table?

[happydentist]

I have many database like 110aa.db with table tb_110, 111aa.db with table tb_111, 112aa.db with table tb_112 ......
How can I iterate loop attach different db and load different table to sqlnotebook?
Thanks

[electroly]

Hi @happydentist, SQLite has an ATTACH DATABASE command that can help here. Here's the documentation, give it a try: https://sqlite.org/lang_attach.html

[happydentist]

Thanks, I can attach sqlite db file.
My question is that how can I iterate loop attach different db and load different table to sqlnotebook in one script

[electroly]

It should be doable. Try using the LIST_FILES function [1] to get a table of all the database files. Then, use a FOR loop [2] to iterate through the list one by one. Use a SELECT query to pull out the next file from the LIST_FILES response and do your attach / load inside the loop.

[1] https://sqlnotebook.com/list-files-func.html
[2] https://sqlnotebook.com/for-stmt.html