mysql.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; for the right syntax to use near ')' at line 1

Question

Am having problems with MySql not recognizing this syntax.

I think the issue is in the the exceute statement. I was using their previous method https://dev.mysql.com/doc/connector-python/en/connector-python-example-cursor-transaction.html

def insertPS3(name,gamedb):
    mycursor = gamedb.cursor()
    mycursor.execute("""INSERT INTO ps3 (name) VALUES (%s,)""" % (name,))
    gamedb.commit()

Edit

'%s' is the fix

Why is there a comma after `%s`? – Scott Hunter Dec 30 '19 at 01:09 — Scott Hunter, Dec 30 '19 at 01:09
I saw in another link that might help – alpha245 Dec 30 '19 at 01:11 — alpha245, Dec 30 '19 at 01:11

score 3 · Answer 1 · answered Dec 30 '19 at 01:34

3

Instead of formatting the SQL statement using python string formatting you should let the cursor handle it for you. Passing a tuple of params as the second argument to execute (the same length as the number of %ss in the statement) will allow the cursor to perform the correct string formatting

mycursor.execute("INSERT INTO ps3 (name) VALUES (%s)", (name,))

answered Dec 30 '19 at 01:34

Iain Shelvington

31,030
3
31
50

2

I fixed it I just need to do ```'%s'``` instead of ```%s``` by it self – alpha245 Dec 30 '19 at 01:41

mysql.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; for the right syntax to use near ')' at line 1

1 Answers1