Python连接数据库

bubuko 2022/1/25 18:56:21 python 字数 3236 阅读 938 0 来源 http://www.bubuko.com/infolist-5-1.html

1. import time import pymysql import pandas as pd from datetime import datetime,timedelta 2. cuor = pymysql.connect(host = "", user = "", password = " ...

import time
import pymysql
import pandas as pd
from datetime import datetime,timedelta

cuor = pymysql.connect(host = "",
                      user = "",
                      password = "",
                      db = "<库名>")

cur = cuor.cursor()

ucol = "record_id pay_channel pay_config_key biz_scenario biz_serial_no pay_amount pay_description response_time pay_status stage user_id our_trans_number third_trans_number receipt create_time update_time".replace(" ",",")
sql1 = "select {0} ".format(ucol)
sql2 = "from mall_pay_record "
sql3 = "limit 10"
ec = cur.execute(sql1+sql2+sql3)
# print(ec)
ecfe = cur.fetchall()
# print(ecfe)

ecpd = pd.DataFrame(ecfe,columns=ucol.split(‘,‘))
ecpd.head()

技术分享图片

Python连接数据库

原文：https://www.cnblogs.com/lxzcloud/p/15194057.html

如果您也喜欢它,动动您的小指点个赞吧

除非注明，文章均由 laddyq.com 整理发布，欢迎转载。

转载请注明：
链接：http://laddyq.com
来源：laddyq.com
著作权归作者所有。商业转载请联系作者获得授权，非商业转载请注明出处。

Python连接数据库

分类汇总

您的鼓励是对我最大的支持