更新:2021.03.08
/************** 自动从远程数据库拉取&存储数据 ***********************/
import pymysql
import pandas as pd
for i in(6,7,8):
sql_cmd = f"SELECT * FROM table where month(字段xx) = {i}"
db = pymysql.connect(host = "xxxxxxxx",
user = "xxxxx",
password = "xxxxxx",
db = "dw" ,
charset = "utf8")
df = pd.read_sql(sql_cmd, db)
df.to_csv(f"D:/data678/dw_fct_sales_{i}月.csv")
# host:数据库地址/本机使用localhost
# user:用户名
# password:密码
# db:数据库名
# charset:数据库编码,一般为UTF-8
#注:如果用户名或密码中包含特殊符号@、%等符号时,需要修改密码方可链接
连接方法:
import pymysql
sql_cmd = "SELECT * FROM fct_sales"
db = pymysql.connect(host = "118.190.201.139",
user = "xxx",
password = "xxxxxxxxxx",
db = "dw" ,
charset = "utf8")
# host:数据库地址/本机使用localhost
# user:用户名
# password:密码
# db:数据库名
# charset:数据库编码,一般为UTF-8
#注:如果用户名或密码中包含特殊符号@、%等符号时,需要修改密码方可链接
df = pd.read_sql(sql_cmd, db)
df.head()
连接本地:
连接远程:
案例①:
案例②: