python mysql绑定变量_Python插入mysql的变量问题

问题

先上代码

import pymysql

import time

import random

import uuid

import threading

# 连接mysql

db = pymysql.connect(host='10.10.100.184', port=3308,

user='root', passwd='3hyHd1MLARaMkUJsr3dp', db='iot')

# 获取mysql操作光标

cursor = db.cursor()

# 初始化变量

count = 0

# 设置sql语句循环次数

print(time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(time.time())))

while count < 5:

count += 1

# 定义mysql字段的范围随机数变量

quyu = random.randint(440300, 440310)

jingdu = random.uniform(99, 117)

weidu = random.uniform(23, 41)

city_list = [11, 12, 13, 14, 15, 25, 35, 37, 38]

city_id = random.choice(city_list)

# driver_name = f"'cs{count}'"

driver_name = 'cs'

print(driver_name)

print(type(driver_name))

driver_type_list = [111,311,812,813,814,911,1111,1211,1311]

driver_type = random.choice(driver_type_list)

online = [0,1]

line = random.choice(online)

# 生成mysql语句插入语句

sql = "insert into assets (`user_id`, `company_id`, `province_id`, `city_id`, `district_id`, `assets_name`, `assets_code`, `device_num`, `zn_device_type_id`, `device_type_id`, `project_id`, `longtitude`, `latitude`, `create_time`, `assets_picture`, `address`, `