pythony与mysql的连接、读取和插入

最新推荐文章于 2022-07-04 16:59:01 发布

louissunset

最新推荐文章于 2022-07-04 16:59:01 发布

阅读量186

点赞数 1

分类专栏：总结

本文链接：https://blog.csdn.net/louissunset/article/details/88599776

版权

总结专栏收录该内容

2 篇文章 0 订阅

订阅专栏

连接

import pymysql as mdb
conn = mdb.connect(host='127.0.0.1', port=3306, user='***', passwd='****', db='***', charset='utf8')
conn.close()

读取

    conn = mdb.connect(host='127.0.0.1', port=3306, user='root', passwd='****', db='*****', charset='utf8')
    cur = conn.cursor()
    sql="SELECT * FROM INSP.single"
    try:
        cur.execute(sql)
        records = cur.fetchall()
        for row in records:
            NLS = row[0]
            ENRICH = str(round(row[5],5))
            SCORE = str(round(row[6],5))
        conn.commit()
    except:
        conn.rollback()
    conn.close()

插入

    conn = mdb.connect(host='127.0.0.1', port=3306, user='***', passwd='****', db='***', charset='utf8')
    cur = conn.cursor()
    sql="insert into userinfo(JobId, Email) values(%s,%s)"
    par=(sys.argv[1],sys.argv[2])
    try:
        cur.execute(sql,par)
        conn.commit()
    except Exception e:
        conn.rollback()
    conn.close()