Correct SQL usage in Python Using PYMYSQL

Question

I am attempting to write a SQL in python using PYMYSQL, which searches a table for a certain record with a set value, however while this sounds simple I cannot seem to do it below is my query:

SELECT Series_ID FROM series_information WHERE Series_Name "'+data +'"'

where the data is the value that I am searching for however the following error occurs:

pymysql.err.ProgrammingError: (1064, '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 \'"Spice And Wolf"\' at line 1')

The problem I believe is that I am not sure how to properly escape the data value if it has spaces in it and therefore would require quotation marks in the SQL query.

blasko · Accepted Answer · 2015-07-15 20:35:02Z

1

You're missing a comparison (like, =, etc) between Series_Name and data, as well as a ';' on the end of the query.

`'SELECT Series_ID FROM series_information WHERE Series_Name = "'+data +'";'

answered Jul 15, 2015 at 20:35

blasko

6904 silver badges8 bronze badges

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

1 Comment

Downdog555 Over a year ago

Many thanks i guess the documentaiton i look at was wrong ;/ but thanks !

iceraj · Accepted Answer · 2015-07-15 20:36:26Z

0

`SELECT Series_ID FROM series_information WHERE Series_Name "'+data +'"'`

Is not a valid SQL query did you mean:

`'SELECT Series_ID FROM series_information WHERE Series_Name like "'+data +'"'`

answered Jul 15, 2015 at 20:36

iceraj

3591 silver badge5 bronze badges

Collectives™ on Stack Overflow

Correct SQL usage in Python Using PYMYSQL

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related