DELETE mysql statement using python

Question

I am new to MYSQL and i am facing a very easy problem with MYSQL. I am creating a database that contains a student table , this table contains the student's name , ID( primary key) . I need to delete a record based on the user's choice of id ( call this variable student_id) , so how to write this in a mysql statement using python ? i have tried this but i know it is wrong -->

cur.execute("Delete FROM students WHERE ID = student_id")

What about it makes you say it is wrong? What library are you using to communicate with your database? — Scott Hunter
– Scott Hunter, Commented Dec 4, 2016 at 17:42
After running query, you need to commit the changes using con.commit() where con is your connection object — Moinuddin Quadri
– Moinuddin Quadri, Commented Dec 4, 2016 at 17:44
@ Scot Hunter i have used this import mysql.connector , if that what you mean . @MoinuddinQuadri I have done so — Joo
– Joo, Commented Dec 4, 2016 at 18:36

ettanany · Accepted Answer · 2016-12-04 19:10:46Z

2

This should work for you:

student_id = int(input('Please, enter an ID: '))  # In Python 3, you need to parse the user input for numbers.

statmt = "DELETE FROM `students` WHERE id = %s"
cur.execute(statmt, (student_id,))
conn.commit()  # You need to commit the transaction

edited Dec 4, 2016 at 19:10

answered Dec 4, 2016 at 17:44

ettanany

20k9 gold badges49 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Joo Over a year ago

Thank you but it didn't worked for me , here is my code for deleting the record : student_id=input('please enter ID') statmt="DELETE FROM student WHERE id = ?" cur.execute(statmt,(student_id,)) conn.commit()

Joo Over a year ago

Note the table name is student. Here is the error :Traceback (most recent call last): File "C:/Users/Ahmed/PycharmProjects/DATABASE/Test2.py", line 42, in <module> cur.execute(statmt,(student_id,)) File "C:\Python34\lib\site-packages\mysql\connector\cursor.py", line 507, in execute "Not all parameters were used in the SQL statement") mysql.connector.errors.ProgrammingError: Not all parameters were used in the SQL statement

ettanany Over a year ago

You use which version of Python?

Joo Over a year ago

my python version is 3.4.0

ettanany Over a year ago

So you need to use student_id = int(input('please enter ID')). Take a look at my edited answer

|

Collectives™ on Stack Overflow

DELETE mysql statement using python

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related