[pymysql usage] #python

a.py

import pymysql

db = pymysql.connect(host="192.168.236.111", user="fakeuser", password="fakepassword",port=xxx, db="xxx")

data = {
    "a": 1,
    "b": "2,3"
}
table_name="detail"
column_string = ','.join(data.keys())
value_string = ','.join([f'%({key})s' for key in data.keys()])

sql = f'INSERT IGNORE INTO {table_name} ({column_string}) VALUES ({value_string})'
print(sql)
cursor = db.cursor()
cursor.execute(sql, data)
db.commit()

gist域名可以直连了~

gist域名可以直连了~

哈哈，不错不错。