Multiple SQL insert with PyMySQL

PythonPower answered on August 4, 2022 Popularity 3/10 Helpfulness 2/10

answer Multiple SQL insert with PyMySQL

Multiple SQL insert with PyMySQL

Comment

import pymysql

con = pymysql.connect(host="localhost", user="myuser", passwd="mypass", db="test")
cursor = con.cursor()

values_to_insert = [(1, 2, 'a'), (3, 4, 'b'), (5, 6, 'c')]
query = "INSERT INTO tab (col1, col2, col3) VALUES " + ",".join("(%s, %s, %s)" for _ in values_to_insert)
flattened_values = [item for sublist in values_to_insert for item in sublist]
cursor.execute(query, flattened_values)

con.commit()

Popularity 3/10 Helpfulness 2/10 Language python

Source: softhints.com

Tags: pymysql python sql-insert

Link to this answer
Share Copy Link

Contributed on Aug 04 2022

PythonPower

0 Answers Avg Quality 2/10

Multiple SQL insert with PyMySQL

Contents

More Related Answers

Multiple SQL insert with PyMySQL

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.