Python 查询数据返回为空的解决办法

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)