Python connector error on trying to delete using user input

Question

I have implemented most other basic database transactions including insert,update,select with similar syntax,but on trying to delete,i get error

mysql.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%s' at line 1

What would the correct syntax be? I must delete according to user input. Here is a shortened version of my code,minus the insert,select,update part.:

elif (choice == 4):
    mail=raw_input('Enter email of user to be deleted:')
    print 'Deleting..'
    delete_user_details(mail)


def delete_user_details(email):

    sql = "DELETE FROM users WHERE email = %s"
    cursor.execute(sql,email)

Knowing error is on the first line, maybe your connection string has some problems? You should post more. — isamert
– isamert, Commented Jun 27, 2016 at 12:50

Eugene Yarmash · Accepted Answer · 2016-06-27 12:54:58Z

4

You need to pass query parameters to cursor.execute() as a tuple, even for a single parameter. Try this:

sql = "DELETE FROM users WHERE email = %s"
cursor.execute(sql, (email,))

edited Jun 27, 2016 at 12:54

answered Jun 27, 2016 at 12:51

Eugene Yarmash

152k44 gold badges346 silver badges391 bronze badges

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

2 Comments

momo Over a year ago

Ah!! Thanks a lot!! I don't know how i missed that in the documentation.

GHandel Over a year ago

Silly syntax error like missing the comma in the tuple was giving me a headache. Always a joy to see the right code and notice the mistake in mine! Thanks

Collectives™ on Stack Overflow

Python connector error on trying to delete using user input

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related