Answers for "how to insert values to database with using dictionary in python"

how to insert values to database with using dictionary in python

placeholders = ', '.join(['%s'] * len(myDict))
columns = ', '.join(myDict.keys())
sql = "INSERT INTO %s ( %s ) VALUES ( %s )" % (table, columns, placeholders)
# valid in Python 2
cursor.execute(sql, myDict.values())
# valid in Python 3
cursor.execute(sql, list(myDict.values()))

Posted by: Guest on February-18-2022

Code answers related to "how to insert values to database with using dictionary in python"

Code answers related to "Python"

Python Answers by Framework

Browse Popular Code Answers by Language

Answers for "how to insert values to database with using dictionary in python"

Code answers related to "how to insert values to database with using dictionary in python"

Code answers related to "Python"

Python Answers by Framework

Browse Popular Code Answers by Language

Answers for "how to insert values to database with using dictionary in python"

Code answers related to "how to insert values to database with using dictionary in python"

Code answers related to "Python"

Python Answers by Framework

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us