db_source.db with tbs1, tbs2 db_dest.db with tbd1, tbd2 conn = sqlite3.connect(db_dest)
sql = """ attach db_source.db as db_source; drop table if exists tbs1 # it is used to check if tbs1 already in db_dest. """ Conn.execute(sql) Above will delete tbs1 from db_source.db it might be a bug cause wrong deletion of tbs1 from db_source I also tried other cases, conn = sqlite3.connect(db_dest) Sql = """ Attach db_source.db as db_source; Select * from tbs1; """ Conn.execute(sql) Above code works, it might also be a bug, it should be "select * from db_source.tbs1", "select * from tbs1" should point to "db_dest.tbs1" instead of db_source.tbs1" _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
