1

I know is possible to insert rows (not by every single values) with this definition:

insert into table1 select * from table2

But what if I need to transfer rows from one database_1 table to another database_2 table? (considering that the number of columns will always match)

I would like something like this:

c_database_2.execute('''SELECT * FROM table 
                        WHERE date = ? 
                        AND timestamp = ?''', (a, b) 
row = c_new.fetchone() 

c_database_1.execute("INSERT INTO table SELECT * FROM ?", (row)) 
user3755529
  • 1,050
  • 1
  • 10
  • 30

0 Answers0