Answers for "select sql query result and insert into python list of dicts"

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 "select sql query result and insert into python list of dicts"