用python在后端将数据写入到数据库并读取

import pandas as pd from sqlalchemy import create_engine # 初始化数据库连接，使用pymysql模块 # MySQL的用户：root, 密码:147369, 端口：3306,数据库：mydb engine = create_engine(‘mysql+pymysql://root:123456@localhost:3306/python1‘) import numpy as np import datetime start = datetime.datetime.now().strftime(‘%Y-%m-%d‘) end = (datetime.datetime.now()+datetime.timedelta(days=100)).strftime(‘%Y-%m-%d‘) # 新建pandas中的DataFrame, 只有id,num两列 df = pd.DataFrame(data=np.random.randint(-100,100,(100,100)),index=pd.date_range(‘2018-1-1‘,periods=100,dtype=‘datetime64[ns]‘, freq=‘D‘),columns=None,dtype=int) print(df.shape) # 将新建的DataFrame储存为MySQL中的数据表，不储存index列 df.to_sql(‘data‘, engine, if_exists=‘append‘,index= True)

 

读取：

# -*- coding: utf-<span style="color: #800080;">8</span> -*-<span style="color: #000000;">
# 导入必要模块
import pandas </span><span style="color: #0000ff;">as</span><span style="color: #000000;"> pd
</span><span style="color: #0000ff;">from</span><span style="color: #000000;"> sqlalchemy import create_engine
# 初始化数据库连接，使用pymysql模块
# MySQL的用户：root, 密码:</span><span style="color: #800080;">147369</span>, 端口：<span style="color: #800080;">3306</span><span style="color: #000000;">,数据库：mydb
engine </span>= create_engine(<span style="color: #800000;">‘</span><span style="color: #800000;">mysql+pymysql://root:123456@localhost:3306/python1</span><span style="color: #800000;">‘</span><span style="color: #000000;">)
# 查询语句，选出employee表中的所有数据
sql </span>= <span style="color: #800000;">‘‘‘
</span>      <span style="color: #0000ff;">select</span> * <span style="color: #0000ff;">from</span><span style="color: #000000;"> student;
      </span><span style="color: #800000;">‘‘‘
</span><span style="color: #000000;">
# read_sql_query的两个参数: sql语句， 数据库连接
df </span>=<span style="color: #000000;"> pd.read_sql_query(sql, engine)
# 输出employee表的查询结果
print(df.shape)</span>

 

用python在后端将数据写入到数据库并读取

标签：语句   imp   ftime   odi   data   sql   one   rom   nbsp