| 12345678910111213141516171819202122232425 |
- # -*- coding: utf-8 -*-
- # Author : Charley
- # Python : 3.10.8
- # Date : 2025/9/23 14:37
- """
- 6000+6位数——6075+6位数
- """
- from mysql_pool import MySQLConnectionPool
- from loguru import logger
- sql_pool = MySQLConnectionPool(log=logger)
- num_list = []
- # for i in range(6000, 6076):
- # for j in range(100000, 1000000): # 6位数范围 100000-999999
- # num_list.append(f"{i}{j:06d}")
- for i in range(6060000000, 6069999999):
- num_list.append(i)
- # print(len(num_list))
- logger.debug(f"开始插入 {len(num_list)} 个数据.......................")
- sql_insert = "insert into cgc_task (cert_id) values (%s)"
- sql_pool.insert_too_many(sql_insert, num_list)
|