python&Pandas七：Pandas从sql库中导入数据的几种方法分析

1.使用mysql-connector-python库将SQL文件导入到Python中，并查询数据库中的表

确保已经安装mysql-connector-python库

#导入模块
import mysql.connector

# 建立与MySQL数据库的连接
conn = mysql.connector.connect(
    host="localhost",
    user="username",
    password="password",
    database="database_name")

# 创建游标对象
cursor = conn.cursor()

#读取SQL文件内容：
with open("path/to/sql_file.sql", "r") as file:
    sql_script = file.read()
cursor.execute(sql_script, multi=True)
conn.commit()

# 执行查询语句
query = "SELECT * FROM table_name"
cursor.execute(query)

# 获取结果集
result = cursor.fetchall()

# 显示结果
for row in result:
    print(row)

# 关闭游标和连接
cursor.close()
conn.close()

"localhost","username","password","database_name"分别替换成，主机名字，sql的用户名字，用户密码，所要导入的数据库名字
"path/to/sql_file.sql"替换为数据库粘贴到pycharm以后得实际路径

"table