安装依赖?br data-filtered="filtered" />
使用 pip 来安?mysql-connector-pythonQ这是一个用于与 MySQL 数据库交互的 Python ?br data-filtered="filtered" />
动程序?br data-filtered="filtered" />
bash
pip install mysql-connector-python
q接数据?br data-filtered="filtered" />
python
import mysql.connector
# q接?MySQL 数据?br data-filtered="filtered" />
mydb = mysql.connector.connect(
host="localhost", # 数据库主机地址
user="yourusername", # 数据库用户名
password="yourpassword", # 数据库密?br data-filtered="filtered" />
database="yourdatabase" # 数据库名U?br data-filtered="filtered" />
)
执行 SQL 查询
# 创徏一个游标对象，通过它我们可以执?SQL 命o
mycursor = mydb.cursor()
# 执行 SQL 查询语句
mycursor.execute("SELECT * FROM yourtable")
# 获取查询l果q打印出?br data-filtered="filtered" />
results = mycursor.fetchall()
for x in results:
print(x)
插入数据
python
# 创徏一个新的记?br data-filtered="filtered" />
mycursor.execute("INSERT INTO yourtable (column1, column2) VALUES (%s, %s)", ("value1",
苏公|安?32061202001004?/p>
