How should I make these commands work where we take a variable on the python program to execute a command in MySQL?

Question

This is a bank management system. where acc_id the account I want to delete from a MySQL Table BANK I have already connected python to mysql but this code dosen't work. Is there any alternative to .format ?

if choice == 2:
    acc_id = int(input("ENTER ACCOUNT NUMBER TO DELETE:"))
    cursor = mydb.cursor()
    cmd2 = "DELETE FROM BANK WHERE ACC_NO = {}".format(acc_id)
    cursor.execute(cmd2)

Gopish Mundada · Answer 1 · 2020-12-18T21:23:42.327

1

user_input = raw_input("Required Data")

cursor.execute("DELETE FROM BANK WHERE ACC_NO = %s", (user_input))

Hopefully, this will help you to solve your problem.

edited Dec 18 '20 at 21:23

answered Dec 18 '20 at 14:15

Gopish Mundada

39
6

How should I make these commands work where we take a variable on the python program to execute a command in MySQL?

1 Answers1