from sqlalchemy import create_engine

import pymysql

engine = create_engine('mysql+pymysql://root:1234@127.0.0.1/jixun?charset=utf8', echo=True, encoding='utf-8', convert_unicode=True)

engine = create_engine('dialect+driver://username:password@host:port/database')

# 用法

# engine = create_engine('dialect+driver://username:password@host:port/database')

# dialect -- 数据库类型

# driver -- 数据库驱动选择

# username -- 数据库用户名

# password -- 用户密码

# host 服务器地址

# port 端口

database 数据库

data1.to_sql('cda_yangyue',engine,if_exists='replace' )

shanghai.to_sql('cda_yangyue',engine,if_exists='replace' )

pd.read_sql('cda_ccc', engine）

pd.read_sql('select * from cda_kuan where 景点名称 REGEXP "博物馆" ', engine)

pd.read_sql('select * from cda_kuan where 景点票价= "44.8"', engine)