用python造数据

插入一条数据

#导包
import pymysql
#创建链接
conn = pymysql.connect(host='localhost',port=3306,user='root',password='123456',db='库名')
#创建游标
cursor = conn.cursor()

cursor.execute("INSERT INTO 库名(id,username,mobie) veluse (${id},${username},${mobile})")

conn.commit()

print('ok')

conn.close()
cursor.close()

循环插入10万条数据

#导包
import pymysql
#创建链接
conn = pymysql.connect(host='localhost',port=3306,user='root',password='123456',db='库名')
#创建游标
cursor = conn.cursor()
#添加sql语句
user_sql = "INSERT INTO 库名(id,username,mobie) veluse (${id},${username},${mobile})"
#循环插入数据
user_start = 100000
for i in range(100000):
    id = user_start + i
    username = "test" + str(id)
    mobile = "18812" + str(id)

    print("插入第{}条数据ID为{}".format(i+1,id))
    sql = id.fromat(id,username,mobile)
    cursor.execute(sql)

conn.commit()
#关闭游标
cursor.close()
#关闭连接
conn.close()