首页 > 其他 > 详细

[转]how to inserting multiple rows in one step

时间:2018-02-26 20:24:19      阅读:172      评论:0      收藏:0      [点我收藏+]

To insert multiple rows in the table use executemany() method of cursor object.

Syntax:
cursor_object.executemany(statement, arguments)

  • statement: string containing the query to execute.
  • arguments: a sequence containing values to use within insert statement.

Let’s take an example.

from __future__ import print_function
 
import MySQLdb as my
 
db = my.connect(host="127.0.0.1",
user="root",
passwd="",
db="world"
)
 
cursor = db.cursor()
name = "Some new city"
 
country_code = 'SNC'
 
district = 'Someyork'
 
population = 10008
 
data = [
('city 1', 'MAC', 'distrct 1', 16822),
('city 2', 'PSE', 'distrct 2', 15642),
('city 3', 'ZWE', 'distrct 3', 11642),
('city 4', 'USA', 'distrct 4', 14612),
('city 5', 'USA', 'distrct 5', 17672),
]
 
sql = "insert into city(name, countrycode, district, population) 
VALUES(%s, %s, %s, %s)"
 
number_of_rows = cursor.executemany(sql, data)
db.commit()
 
db.close()

[转]how to inserting multiple rows in one step

原文:https://www.cnblogs.com/everfight/p/execute_manysql.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!