Delete rows with pyodbc freezes and doesn't delete rows

Asked Sep 07 '19 at 15:45

Active Oct 21 '21 at 18:32

Viewed 260 times

I am writing a script to remove rows from a SQL Azure database. When I execute this script in Jupyter notebook it runs forever and never deletes the rows. Any ideas why this script is not executing?

key = input("Enter key to remove\n")  
cnxn = pyodbc.connect(
    'DRIVER='+driver+';SERVER='+server+'; UID='+username+';PWD='+ password)
cursor = cnxn.cursor()
sql = "DELETE FROM Customer where CustomerID like '{key}%'"
process = sql.format(key = key)
cursor.execute(process)
cursor.commit()

edited Oct 21 '21 at 18:32

Toni

1,555
4
15
23

asked Sep 07 '19 at 15:45

Rubiks

How big is the Customer table? If it's really big, this process could legitimately take a while. – John Gordon Sep 07 '19 at 16:01
You explicitly called out "executing this script in Jupyter." Does the same script succeed for you in other environments? – Hans Musgrave Sep 07 '19 at 16:13
at what comand does it freeze? Try to put each command in a separate cell – silent Sep 07 '19 at 16:58
It is a small table, only contains a few hundred records and the script freezes in all environments. – Rubiks Sep 08 '19 at 02:17
It freezes at execute() – Rubiks Sep 08 '19 at 02:18

Delete rows with pyodbc freezes and doesn't delete rows

0 Answers0