Use Python to manipulate MySQL database (BULK insert data)

#!/usr/bin/env python#-*-coding:utf-8-*-import mysqldb# Establish Connection conn = MySQLdb.connect (host= ' 127.0.0.1 ', user= ' root ', Passwd= ' 1qaz#edc ', db= ' test_db ') cur = conn.cursor () #对数据进行操作li = [(' Tanzhenx ', ' Shaoguan '), (' Huangmengdie ', ' Shaoguan ') ] #定义一个列表, the list contains multiple tuples, and so on, the data in each tuple is inserted in bulk cur.executemany (' INSERT into user (name,address) VALUES (%s,%s) ', Li) # BULK INSERT Data Conn.commit () #提交请求, otherwise the data is not written to the database # Close database connection cur.close () Conn.close ()

This article is from the "Fa&it-Q Group: 223843163" blog, please be sure to keep this source http://freshair.blog.51cto.com/8272891/1876288

Use Python to manipulate MySQL database (BULK insert data)