#第一种连接mysql数据库的方式 import pandas as pd from sqlalchemy import create_engine engine = create_engine("mysql+pymysql://{}:{}@{}:{}/{}".format('root', '密码', '数据库地址', '3306', '数据库')) sql_query = 'select * from wp_users' # 使用pandas的read_sql_query函数执行SQL语句,并存入DataFrame df_read = pd.read_sql_query(sql_query, engine) print(df_read)
#第二种连接mysql数据库的方式 import pandas as pd import numpy as np import pymysql conn = pymysql.connect( host='数据库地址', user='root', password='密码', database='数据库', charset='utf8' ) cursor = conn.cursor() cursor.execute("SELECT VERSION()") data = cursor.fetchone() print("Database version : %s " % data)