使用py脚本造测试数据

sql = """insert into 'user'('id','username''password','nick_name','user_photo','user_sex','account_balance')
values """
for index in range(0,100000):
    sql = sql + """(null,'{0}','1','测试账户{1}',null,null,0),""".format(138+index,index)
print(sql)

f = open(r"E:/23456.txt","w",encoding  = "utf-8")
f.write(sql)
f.close()