python连接数据库并进行查询、插入等操作

最新推荐文章于 2024-04-11 18:13:02 发布

KimihaSukiDa

最新推荐文章于 2024-04-11 18:13:02 发布

阅读量334

点赞数

本文链接：https://blog.csdn.net/weixin_40841243/article/details/107491304

版权

 db = pymysql.connect(host=cls.host, port=cls.port, user=cls.user, passwd=cls.passwd, db='')
        cur = db.cursor(cursor=pymysql.cursors.DictCursor)
        sql = "select XXX from XXX where "
        cur.execute(sql)
        data = cur.fetchall()
        sql = "INSERT INTO user(username,auth_key,password_hash,nickname,moego_code,created_at,phone)" \
              " VALUES(\"{}\",\"{}\",\"{}\",\"{}\",\"{}\",{},\"{}\")". \
            format(username, auth_key, password_hash, nickname, moego_code, timestamp, phone)
        cur.execute(sql)
        db.commit()
        db.close()