Values in mysql with python

Asked Oct 06 '15 at 15:56

Active Oct 07 '15 at 06:21

Viewed 27 times

I'm trying to do a little program for print an user that it was selected in a list. But I don't know how to mix a variable with a query. I tried this but I get an error:

def datos(name):
conn = MySQLConnection(host=DB_HOST,user=DB_USER,password=DB_PASS,database=DB_NAME)
cursor = conn.cursor()
cursor.execute("SELECT nombre FROM clientes WHERE nombre = %s", name)

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

edited Oct 06 '15 at 15:59

jonrsharpe

115,751
26
228
437

asked Oct 06 '15 at 15:56

Daniel Palacín

1

You might find you need to use e.g. `?` instead of `%s` for that system - have you read the manual? – jonrsharpe Oct 06 '15 at 15:58
No. It doesn't work. I have the same error but ? instead of %s. – Daniel Palacín Oct 06 '15 at 16:19

Values in mysql with python

0 Answers0