insert list of dict into MySQL using Python [closed]

Question

I want to insert a list like that ,but much larger. list=[{"name":"Tom","gender":"male",},{"name":"Jack","gender":"male",},{"name":"Lee","gender":"male",}] into MySQL using python,to build a table. I have already import MySQLdb .What should I do then?

Answer 1

Assuming you have a table named foo with name and gender columns, here is how you can use executemany() to insert this list of dictionary into the table:

import MySQLdb

db = MySQLdb.connect(...)
cursor = db.cursor()

data = [
    {"name":"Tom", "gender":"male"},
    {"name":"Jack", "gender":"male"},
    {"name":"Lee", "gender":"male"}
]
cursor.executemany("""
    INSERT INTO foo (name, gender)
    VALUES (%(name)s, %(gender)s)""", data)
db.commit()