Answers for "how to insert data into table in python from list of dictionaries"

sql insert query list of dictionaries

cursor.executemany("""
    INSERT INTO 
        mytable
        (id, price, type)
    VALUES
        (%(id)s, %(price)s, %(type)s)
""", lst)

Posted by: Guest on December-11-2020

Code answers related to "how to insert data into table in python from list of dictionaries"