When you have a table called X in the Workbench (in which you have columns called value1, value2) and you define a list called A=[1,2,3] in Python, what should I do with this Python mysql code? For example, the Value column of X has the same value as A[2]
"Select X.value2 where X.value1=A[2]" I want to write a code with this meaning.
import pymysql
a = [1,2,3]
db = pymysql.connect(host='', port=3306, user='',passwd='', db='', charset='utf8')
cur = db.cursor()
sql = "select value2 from Table where value1=%s"
cur.execute(sql,(a[2]))
r = cursor.fatchall()
for i in r:
print(i)
There are many use cases of pymysql on Google.
© 2024 OneMinuteCode. All rights reserved.