I would like to have a connection between my python code and a SQL database. I have read several ways to do it , but I am failing to get the results.
conn = pymysql.connect(user=X,passwd=X,host=X,port=X,database=X, charset='utf8', autocommit=True)
curs = conn.cursor()
try:
curs.execute('SELECT id,sing_name,bir_yr FROM singers_list WHERE bir_yr = ? ',year)
data = curs.fetchall()
for i in data:
yield " Data: " + str(i) + "<br/>"
except:
yield " Failed to get data from base<br/>"
Where year is an int python variable. I am getting the proper results with:
curs.execute('SELECT id,sing_name,bir_yr FROM singers_list)
Which means I am connecting successfully to the database . How can I include variables in queries ? (not only integers , but strings too or any type)
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…