python中多行字符串的展示：用”’ ”’或者 “”” “”” 来表示，即可展示多行字符串。

Pandas初试

import pandas as pd
from sqlalchemy import create_engine

engine = create_engine('mysql+pymysql://wpadmin:wpadmin@localhost:3306/test')
sql = """SELECT
        *
    FROM
        student
    WHERE
        id = '12345';"""
query = pd.read_sql_query(sql, engine)
print(query)

df_write = pd.DataFrame({'id': ['12', '13'], 'code': ['someshit', 'shitagain']})
# if_exists='append'意思是如果student表存在，则向表中追加数据
df_write.to_sql('student', engine, index=False, if_exists='append')

Python连接mysql数据库极简教程（pandas）