Python 查询数据返回为空的解决办法
常用的方法如下:但是返回数据为空
import mysql.connector
# 创建数据库连接
mydb = mysql.connector.connect(
host="localhost", # 数据库主机地址
user="name", # 数据库用户名
passwd="name", # 数据库密码
database="jenkinsdata", # 数据库表
charset='utf8'
)
mycursor = mydb.cursor()
# tscgarmanage projectlinshi
#sql = "SELECT * FROM tscgarmanage WHERE Chinese = '遵义'"
name = 'VideoServerExceptionfJYNFVqV'
sql = "SELECT * FROM projectlinshi WHERE Source = 'VideoServerExceptionfJYNFVqV'"
mycursor.execute(sql)
myresult = mycursor.fetchall()
print(myresult)
更正方法如下:因为execute的参数有要求要以如下方式:
import mysql.connector
# 创建数据库连接
mydb = mysql.connector.connect(
host="localhost", # 数据库主机地址
user="name", # 数据库用户名
passwd="name", # 数据库密码
database="jenkinsdata", # 数据库表
charset='utf8'
)
mycursor = mydb.cursor()
# tscgarmanage projectlinshi
#sql = "SELECT * FROM tscgarmanage WHERE Chinese = '遵义'"
name = 'VideoServerExceptionfJYNFVqV'
mycursor.execute( "SELECT * FROM projectlinshi WHERE Source = %s", (name,))
myresult = mycursor.fetchall()
print(myresult)