How to merge N SQLite database files into one if db has the primary field?

Question

I have a bunch of SQLite db files, and I need to merge them into one big db files.

• How can I do that?

Added

Based on this, I guess those three commands should merge two db into one.

attach './abc2.db' as toMerge;
insert into test select * from toMerge.test
detach database toMerge

The problem is the db has PRIMARY KEY field, and I got this message - "Error: PRIMARY KEY must be unique".

This is the test table for the db.

CREATE TABLE test (id integer PRIMARY KEY AUTOINCREMENT,value text,goody text)

Answer 1

I'm not 100% sure, but it seems that I should read all the elements and insert the element (except the PRIMARY KEY) one by one into the new data base.