目录
1. 使用 pip 命令安装 mysql-connector
python -m pip install mysql-connector
示例代码
import mysql.connector
db = mysql.connector.connect(
host="localhost",
user="root",
passwd="********",
database="learn_test"
)
cursor = db.cursor()
cursor.execute("SELECT * FROM test1")
data = cursor.fetchall()
print(data)
db.close()
2. 使用 pip 命令安装 mysql-connector
pip3 install PyMySQL
示例代码
import pymysql
db = pymysql.connect(
host="localhost",
user="root",
passwd="******",
database="learn_test"
)
cursor = db.cursor()
cursor.execute("SELECT * FROM test1;")
data = cursor.fetchone()
print(data)
db.close()