import requestsimport jsonimport reimport pymysqldb = pymysqlconnecthost=103214173233 port=3306 user=caoliu passwd=xX300400 db=caoliu cursor = dbcursorpattern = recompiler_blank id=t ids = patternfind
import random
随机取出一个id值
random_id = random.choice(ids)
判断数据库中是否存在该id值
while True: cursor.execute(f"SELECT * FROM huifu WHERE id = {random_id}") result = cursor.fetchall() if result: random_id = random.choice(ids) else: break
打印不重复的id值
print(random_id)
将不重复的id值写入数据库
cursor.execute(f"INSERT INTO huifu (id) VALUES ({random_id})") db.commit()
原文地址: https://www.cveoy.top/t/topic/jgHT 著作权归作者所有。请勿转载和采集!