【MySQL】python 插入单条数据 / 批量数据

MySQL插入单条数据

正确操作

def insertData():
    conn = pymysql.connect(host="localhost", user="root", password="xxxxxx", db="pyDB", charset="utf8")
    cur = conn.cursor()
    sql = "INSERT INTO test(name,value)VALUES ('%s', '%f