python - MySQL + python 表 FETCH 模块

Question

name=input("input CUSTOMERID to search :")

    # Prepare SQL query to view all records of a specific person from
    # the SALESPRODUCTS TABLE LINKED WITH SALESPERSON TABLE.
    sql =    "SELECT * selling_products.customer \
              FROM customer \
              WHERE customer_products.CUSTOMERID == name"

    # Execute the SQL command
    cursor.execute(sql)

    # Fetch all the rows the sql result of SQL1.
    results = cursor.fetchall()
    print("\n\n****** TABLE MASTERLIST*********")
    print("CUSTOMERID \t PRODUCTID \t DATEOFPURCHASE")
    print("**************")

    for row in results:
        print (row[0],row[1],row[2])

Python 会编译上面的代码，但不会返回任何输出。非常感谢您的帮助:)

Answer 1

我认为你的sql应该是:

sql =    """SELECT * selling_products.customer 
          FROM customer 
          WHERE customer_products.CUSTOMERID == {name}""".format(name=name)