[sqlite] (python) how to define unchangeable global ID in a table?

Dear all I have 2 string lists, listA and listB as raw data which need to be store in the SQLITE database, both of them may have duplicated records listA listB === orangejapan pear

Re: [sqlite] Multiple databases

I would be very interested to follow-up this subject closely, as we are actually performing the same kind of work as you are looking for. One of the answer you got was that it is not possible to reuse a prepared statement from one database to another. This answer was too quick, and did not