1、原SQL语句:
insert into user(id,name,info) values("001","admin","student");
2、批量生成10条SQL语句,如:
import uuid
for i in range(1, 10):
id = str(uuid.uuid1()).replace("-", "")[0:8]
name = "admin" + str(i)
info = "student!"
sql = 'insert into user(id, name, info) values("%s", "%s", "%s")' % (id, name, info)
with open("D:\\test_user.txt", 'a')as f:
f.write(sql)