How to use quotes at conditional SQL statement into Python read_sql methods

Q&A DQ Courses
#1

image
image.png707×33 4.61 KB

#2

Feel free to use single and double quotes together.

table = pd.read_sql("select * from TABLE where t.month='2019/10' ", con)

or escape them with backslash:

table = pd.read_sql("select * from TABLE where t.month=\"2019/10\" ", con)

or use triple quotes…

Look for more here: https://stackoverflow.com/a/9050384/4440387

#3

It works ! I remember the quotes regulation of Python at fundamental course but cannot find the module ^^