MySQL数据库批量写入python脚本

最新推荐文章于 2024-03-30 14:01:00 发布

panfengblog

最新推荐文章于 2024-03-30 14:01:00 发布

阅读量204

点赞数 1

分类专栏：数据库文章标签： mysql python

本文链接：https://blog.csdn.net/weixin_44338712/article/details/106451993

版权

数据库专栏收录该内容

9 篇文章 0 订阅

订阅专栏

MySQL数据库批量写入python脚本

这是一个个人信息的数据库批量写入的脚本，随机生成的一些数据，如有变动，可以在代码上稍作修改即可

import pymysql
import random
db = pymysql.connect(
    user = "root",
    password = "qwer",
    host = "localhost",
    database = "utf8"
)
cursor = db.cursor()
IDnumber_pre = "1010"
Phone_pre = "(86)1"
Country_pre = "CN"
Address_pre = "RM 1-10,THRD,HY District,WH"
randnum = ""
for i in range(100):
    randnum += str(random.randint(0,9))
for i in range(1):
    IDnumber = IDnumber_pre + ''.join(random.sample(randnum,14))
    name = (''.join(random.sample("abcdefghijklmnopqrstuvwxyz",8))).title()
    Phone = Phone_pre + ''.join(random.sample(randnum,10))
    Country = random.choice(["CN", "US", "UK"])
    Address = Address_pre
    Email = ''.join(random.sample("abcdefghijklmnopqrstuvwxyz123456789" , random.randint(5,15))) + "@" + random.choice(["qq.com", "163.com", "wuhan.com"])
    DataOfBirth = str(random.randint(1920,2020)) + "-" +  str(random.randint(1,12)) + "-" + str(random.randint(1,28))
    print(IDnumber, name, Phone, Country, Address, Email, DataOfBirth)
    sql = "insert into PassengerInfo(IDNumber,Name,PhoneNumber,Country,Address,Email,DataOfbirth) value('%s','%s','%s','%s','%s','%s','%s')" % (IDnumber, name, Phone, Country, Address, Email, DataOfBirth)
    try:
        cursor.execute(sql)
    except Exception as e:
        print(e)
    else:
        print(sql)
db.commit()
cursor.close()
db.close()