pandas sqlite - No such column with variable

Question

I am using pd.read_sql_query to take data from sqlite to pandas. No surprises but the below works as expected.

import sqlite3
import pandas as pd

conn = sqlite3.connect('AmApp.db')
sql = """SELECT * FROM clients WHERE first_name='john'""", conn)
df = pd.read_sql_query(sql, conn)
print (df)

However as soon as I add a variable into first name, as below, I get the error:

pandas.io.sql.DatabaseError: Execution failed on sql 'SELECT * FROM clients WHERE first_name=john': no such column: john

import sqlite3
import pandas as pd

conn = sqlite3.connect('AmApp.db')
sql = """SELECT * FROM clients WHERE first_name={}""".format('john'))
df = pd.read_sql_query(sql, conn)
print (df

I do not quite understand where i am going wrong with this.

TRY THIS sql = """SELECT * FROM clients WHERE first_name='{}'""".format('john')) — Yuan
– Yuan, Commented Aug 2, 2019 at 10:54

Anthony Kong · Accepted Answer · 2019-08-02 10:55:17Z

2

You need to put quotes around the value:

sql = """ SELECT * FROM clients WHERE first_name='{}' """.format('john'))

answered Aug 2, 2019 at 10:55

Anthony Kong

41.4k52 gold badges193 silver badges325 bronze badges

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

Collectives™ on Stack Overflow

pandas sqlite - No such column with variable

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related