1、方式1:创建插入数据的sql语句(单条插入)
import random
for i in range(0, 10):
list = ['aa', 'bb', 'cc', 'dd', 'ee', 'ff', 'gg', 'hh']
ADMDVS_NAME = random.sample(list, 1) # 随机抽取一个list值
a = "INSERT INTO `eiot_manager_copy`.`admdvs_mapping`(`ID`, `ADMDVS_CODE`, `ADMDVS_NAME`, `XZQH_CODE`, `XZQH_NAME`) VALUES ('%s', '20220706%d', '%s', '632800', '%s');"%(str(i+1), i+1, ADMDVS_NAME, ADMDVS_NAME)
with open("n.txt", "a") as fp: # n.txt为文件名,可自定义
fp.write(a+"\n")
执行结果如下:
INSERT INTO `eiot_manager_copy`.`admdvs_mapping`(`ID`, `ADMDVS_CODE`, `ADMDVS_NAME`, `XZQH_CODE`, `XZQH_NAME`) VALUES ('7&