Why is this is showing 1064 (42000): You have an error in your SQL syntax?

Asked Nov 23 '17 at 18:40

Active Apr 04 '23 at 02:50

Viewed 442 times

It is showing an error in SQL syntax:

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

Code:

if(options==2):
    query = ("SELECT Sl_NO,Title,Genre FROM dvdstore WHERE Genre = %s")
    genre_type = raw_input("Enter the type of genre: ")
    print genre_type
    try:
        y=x.execute(query,(genre_type))
        print y 
        for (Sl_NO,Title,Genre) in x:
            print Title

    except Error as error:
        print(error)

edited Nov 23 '17 at 18:47

ekhumoro

115,249
20
229
336

asked Nov 23 '17 at 18:40

Prashant Jha

Put the `genre_type` before the `query` then put `query = (".... = %s", query)` – kstullich Nov 23 '17 at 18:42
What type is `x`? – Matt Gibson Nov 23 '17 at 18:45
conn = mysql.connector.connect(host='localhost',database='dvdstore',user='root',password=' ') x = conn.cursor() – Prashant Jha Nov 23 '17 at 18:48
– Prashant Jha Nov 23 '17 at 18:56
What happens if you use `y=x.execute(query,(genre_type,))` ? Note the trailing comma in the tuple. – Matt Gibson Nov 23 '17 at 19:15
(And see also https://stackoverflow.com/questions/7992559/python-tuple-trailing-comma-syntax-rule) – Matt Gibson Nov 23 '17 at 19:18
Thanks.... It solved my problem.. – Prashant Jha Nov 24 '17 at 12:54

Why is this is showing 1064 (42000): You have an error in your SQL syntax?

0 Answers0