pymysql insert插入字典

import  pymysql

conn = pymysql.connect(host="127.0.0.1",
                       port=3306,
                       user="username",
                       password="password",
                       db="database_name",
                       charset='utf8mb4',
                       cursorclass=pymysql.cursors.DictCursor,)

def insert(table_name,data):
    with conn.cursor() as cursor:
        cols =  ", ".join('`{}`'.format(k) for k in data.keys())
        placeholders =', '.join('%({})s'.format(k) for k in data.keys())

        insert_sql=f"INSERT INTO {table_name} ({cols}) VALUES ({placeholders})"
        print(insert_sql)
        cursor.execute(insert_sql,data)

​​https://stackoverflow.com/questions/46256965/is-it-possible-to-insert-dictionary-with-pymysql​​