python - ModuleNotFoundError：没有名为 'mysql'12 的模块

Question

我正在运行以下代码，但希望从测试数据库中的学生表中获取记录。

这是我的代码：

import mysql.connector
word = input("Enter a word in English and press Enter: ")
con = mysql.connector.connect(
    user="root", 
    password = "root", 
    host="localhost", 
    database = "test"
)
cursor = con.cursor()
query = cursor.execute("SELECT * FROM student")
results = cursor.fetchall()
if results:
    for result in results:
        print(result[1])
else:
    print("We couldn't find any results about that.")

结果如下：

Traceback (most recent call last):
  File "g:/python learning/mysqlconnector.py", line 1, in <module>
    import mysql.connector
ModuleNotFoundError: No module named 'mysql'

标签： pythonmysqlconnection

Answer 1

尝试使用命令

pip install mysql-connector

在终端或 cmd()