python往mysql数据库中写入数据和更新插入数据

概述1. 连接mysql import pymysqldb = pymysql.connect(host=‘localhost‘, user=‘root‘, password=‘123456‘, port=3306, db=‘spiders‘)cursor = db.cursor()sql = ‘select * from students;‘cursor.execute(sql) 1. 连接MysqL

import pyMysqLdb = pyMysqL.connect(host=‘localhost‘,user=‘root‘,password=‘123456‘,port=3306,db=‘spIDers‘)cursor = db.cursor()sql = ‘select * from students;‘cursor.execute(sql)cursor.close()db.close()

  2. 多字段动态插入MysqL数据库中

import pyMysqLdb = pyMysqL.connect(host=‘localhost‘,db=‘spIDers‘)data = {    ‘ID‘: ‘20180606‘,‘name‘: ‘lily‘,‘age‘: 20}table = ‘students‘keys = ‘,‘.join(data.keys())values = ‘,‘.join([‘%s‘] * len(data))sql = ‘INSERT INTO {table}({keys}) VALUES ({values})‘.format(table=table,keys=keys,values=values)try:   cursor.execute(sql,tuple(data.values()))   print(‘Successful‘)   db.commit()except:   print(‘Failed‘)   db.rollback()cursor.close()db.close()

  3. 数据更新插入MysqL数据库中

import pyMysqLdb = pyMysqL.connect(host=‘localhost‘,‘age‘: 25}table = ‘students‘keys = ‘,‘.join([‘%s‘] * len(data))sql = ‘INSERT INTO {table}({keys}) VALUES ({values}) ON DUPliCATE KEY UPDATE‘.format(table=table,values=values)update = ‘,‘.join([" {key} = %s".format(key=key) for key in data])sql += updatetry:   cursor.execute(sql,tuple(data.values())*2)   print(‘Successful‘)   db.commit()except:   print(‘Failed‘)   db.rollback()cursor.close()db.close()

总结

以上是内存溢出为你收集整理的python往mysql数据库中写入数据和更新插入数据全部内容，希望文章能够帮你解决python往mysql数据库中写入数据和更新插入数据所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。