I want to change "Stamford Lables" under supplier_name to "Stamford Labels". I used the following.
UPDATE branch_supplier
SET supplier_name = "Stamford Labels"
WHERE supplier_name="Stamford Lables" and branch_id = 3;
This however does not work and the program just halts and does not do anything and just give timeout message a moment later.
I appreciate any help.
Other details:
branch_id and supplier_name are the primary keys.
Error Message:
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
Update: I found the issue. I was using mysql.connector in Python to access the server. I forgot to put db.commit() so my previous processes must be blocking it. I kill all the processes and now the update query works.
