pyodbc - insert into 'select' not working

Question

I am trying to run INSERT INTO SELECT statement in cur.execute. The code executes without any error, but there are no records inserted in the table.

Here is the table data:

I execute the following query,

cursor = conn.cursor()
query = 'INSERT INTO destination_test_hist SELECT * FROM destination_test'
cursor.execute(query)
conn.commit()

Where am I going wrong? I need some assistance

Answer 1

Syntax-wise, I don't see any errors.

Just a few simple things to check to be sure:

Check that your connection is correct and you are checking that server/db, your source table(in this case destination_test) and target table (in this case destination_test_hist) are correct.

Answer 2

Check your database environment and relevant tables in the same. You might have checked the QA test environment maybe or post the query with output of no records with database name and tables.

Also, at programming level it may appear that it might not have got executed in the database do debug the query output what it returns at programming level too.