python操作mysql

con = pymysql.connect(host=mysqlhost, user=mysql_user, password=password, db='test', charset='utf8')
sql_str = '%s'
cur=con.cursor()
sql_value=','.join([sql_str for i in range(len(data))])
sql=f"insert into space(spaceid,level,spacename,parentid,code)values({sql_value})"
    # sql=f"insert into defspace(spaceid,level,spacename,parentid)value({spaceid},{level},{spacename},{parentid})"
cur.execute(sql,data)
con.commit()
cur.close()
con.close()