 复制import pymysql def main(): # 创建Connection连接 conn = pymysql.connect(host=localhost,索引试官 port=3306, database=db_test, user=root, password=deepin, charset=utf8) # 获得Cursor对象 cursor = conn.cursor() # 插入10万次数据 for i in range(100000): cursor.execute("insert into index_test values(haha-%d)" % i) # 提交数据 conn.commit() if __name__ == "__main__": main() 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18. |