python - 使用变量 python 从 mysql 读取/存储

Question

关闭。此题需要 details or clarity 。目前不接受答案。

---

想要改进这个问题吗？通过 editing this post 添加详细信息并澄清问题.

已关闭 8 年前。

Improve this question

我是使用 mysql 的新手，我正在尝试从数据库中检索并将其打印/存储在变量中。到目前为止我已经这样做了:

import mysql.connector

conn = mysql.connector.connect(database = 'UserInfo')

mycursor = conn.cursor()


Username = "Max"

Login = ("SELECT username, password FROM UserInfo.User "
         "WHERE username = '%s'")
mycursor.execute(Login, (Username))

print((username, password) in mycursor)

mycursor.close()
conn.close()

Answer 1

您需要使用fetchone()或fetchall()来检索结果:

username = "Max"
query = """
    SELECT 
        username, password 
    FROM 
        UserInfo.User
    WHERE 
        username = %s
"""

mycursor.execute(query, (username, ))
username, password = mycursor.fetchone()  # here we can unpack the tuple returned from fetchone