# 数据查询import pandas as pd
sql ="SELECT * FROM 数据库表名"
result = pd.read_sql(sql, con=con)print(result)# 数据操作: 插入,删除,更新等
sql ="INSERT/DELETE/UPDATE/..."
mycursor.execute(sql)
2. sqlalchemy + pandas
连接MySQL数据库:
from sqlalchemy import create_engine
engine = create_engine("mysql+pymysql://{}:{}@{}/{}?charset=utf8mb4".format('root','密码','x.x.x.x:3306','数据库名'))
con = engine.connect()print("成功连接数据库!")
执行SQL语句:
# 数据查询import pandas as pd
sql ="SELECT * FROM 数据库表名"
result = pd.read_sql_query(sql, engine)print(result)# 插入数据,replace重写表数据/append追加表数据
data.to_sql(name='数据库表名', con=conn, if_exists='replace/append', index=False)