[单表sql，sql table读写]#tags:IO,sql

sql.py

###sql文件信息读写
import tushare as ts
import pymysql
import pandas as pd
from pandas import DataFrame as df
#下载数据并写入
a=ts.get_today_all()
from sqlalchemy import create_engine
e=create_engine('mysql+pymysql://'+'root:1235@localhost/yaotest?charset=utf8')
a.to_sql('a',e,if_exists='replace')
#从数据库读取数据
b=pd.read_sql_table('a',e) #将整个表读取出来并直接生成了DataFrame
b.head()