Python之pymysql操作MySQL数据库

# import pymysql
# import random
# import time
# mysql = pymysql.connect(
#     host='192.168.1.124',
#     user='root',
#     password='123456',
#     database='task1'
# )
# mail_lst = ['@163.com','@sougou.com','@souhu.com','@baidu.com','@sina.com']
# mycursor = mysql.cursor()
# 数据库中插入3000000条数据
# for i in range(3000000):
#     username = '张' + str(i).zfill(7)
#     usermail = username+random.choice(mail_lst)
#     sql = "insert into userinfo(name,mail) values(%s,%s);"
#     mycursor.execute(sql,(username,usermail))
# mysql.commit()
# sql = 'select * from userinfo limit 10;'
# mycursor.execute(sql)
# res = mycursor.fetchall()
# for i in res:
#     print('%-10s%-20s%-50s'%(i[0],i[1],i[2]))