Question

How to insert multiple rows (records) into MySQL database table with Python

Answer 1

# c:\Users\user_nm\AppData\Local\Programs\Python\Python35-32\Scripts\pip install mysql-connector
  
import mysql.connector
  
db = mysql.connector.connect(
    host="localhost",
    user="root",
    passwd="",
    database="python_database"
)
 
db_cursor = db.cursor()

sql = "INSERT INTO workers (first_name, profession) VALUES (%s, %s)"
val = [
    ('Fox', 'C Programmer'),
    ('Aurora', 'C++ Programming'),
    ('Amy', 'Python Programmer'),
    ('Arthur', 'Java Programmer')
]

db_cursor.executemany(sql, val)

db.commit()

print("A total of:", db_cursor.rowcount, "record inserted")

 
'''
run:

A total of: 4 record inserted

'''

 

70+ SQL courses for beginners and professionals