# -*- coding:utf-8 -*-
import mysql.connector
# 数据库连接,password为数据库的密码,db_name为已有数据库名字
conn = mysql.connector.connect(user='root', password='', database='db_name', use_unicode=True)
cursor = conn.cursor()
# 创建word表,键secret
cursor.execute('create table word (secret varchar(100) primary key)')
# 打开存有激活码的文本文件
with open('a.txt', 'r') as f:
for line in f:
# 插入激活码
cursor.execute('insert into word(secret) values (%s)', [line.strip()])
# 提交事务
conn.commit()
# 关闭连接
cursor.close()
conn.close()